Formula: to sum a number column filtered date?

Hi! What is the formula to Sum the Amount Column in the dummy table below, but is filtered only by 2022 year? Seems simple but I can’t get it.

(If I pre-filter the table by Year = 2022 and then use the column menu of “Summarize - Sum - Add to Canvas” it doesn’t respect the filter and will summarize the total amount of all rows).

Hi David

The formula will take this form: thistable.Filter(year=2022). Amount. Sum().


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.