Is there a formula to sum all rows?

Is there a formula to sum all rows, rather than using a filter function like this?

[Table].Filter(Name.IsNotBlank()).[Month].Sum()

Its basically the summarize function that Coda already has, but I want to use that value in a formula. How do i do that?

Hello @yscias
As far as I know, if you want to use that information you should write the formula like you did. I’ve seen several post asking to have an easier access to those summarize informations.
Til then this is indeed kind of CODA DNA to work with Table.Filter(X).Column.Function/Process

The advantage with the chain syntax is that you can see the all construction directly

Have a nice day

Q.

4 Likes