Filter rows, then sum

1

Hello everyone. I am a rank newbie.

From a table called “Field Service Report” with a date column called Date and a duration column called Hours, I want to total Hours for the current month only. This is the formula I came up with:

Sum(Filter([Field Service Report].Hours,month(last([Field Service Report].Date))=Month(today())))

The table is currently prefiltered to show only the current month’s entries. But I want the formula to work whether the table is prefiltered or not.

However, the formula is returning the total for the entire table (including the hidden rows). (1) What am I misunderstanding or doing wrong? (2) Any suggestions?

Thanks!

2

Hi Jim. Does this help?

[Table 1].Filter(Month(Date)=Month(Today())).Hours.Sum()

3 Likes
3

Worked perfectly. I see my syntax was way off the mark. Need to study formula writing. Thanks for your help!

2 Likes
4

I had a similar problem and your solution worked perfectly for me as well. Thanks Nick!

5

Thanks, Nick! I’ll try what I mean first next time—Coda is pretty intuitve.