Hello! Im trying to get the sum of calories from the classes table where the month == < a certain month> … Anyone know what Im doing wrong here?
Thx!
1 Like
See if this works (I didn’t test it).
Classes.Filter(Month = thisRow.Month).Calories.Sum()
It might be better to make Classes.Month a Lookup column to [Table 2].
Then your formula would read like this:
Classes.Filter(Month = thisRow).Calories.Sum()
3 Likes
Hey Ander! I tried the initial formula you provided and it worked. Thank you so much!! I had tried so many different things 
2 Likes