Summary row Sum and Added to canvas different results

1

Hey folks
I’m doing a column sum on a filtered table (some rows don’t display because of the filter)
Oddly the sum in the summary row an added to the canvas show different results (the sum added to the canvas doesn’t take the filter into account, and sums the whole table)
Has anyone encountered this kind of issue?
I have no idea where it comes from
Thank you

2

Hi @Iko_The_Lost_Bay ,

Try doing the same but using a ‘View’ instead of a ‘Table’.

If you use a view, the filters currently applied to it will be considered for the calculation.

Let me know if this helped!

Pablo

1 Like
3

Hey Pablo
yes that solved it,
thank you so much
I’m not sure I understand the logic behind it, mostly the part where the sum in the summary row is different from the sum displayed in canvas.

4

Hi @Iko_The_Lost_Bay ,

I have the feeling the summary row is its own thing, a bit disconnected from other objects and the Coda Formula Language. It’s just displaying what the current user has filtered in the table.

The summary displayed in the canvas is just a formula, that Coda creates automatically for you. You could do the same by just going somewhere in the canvas, typing = and then writing the formula yourself.

In Coda Formula Language, when you refer to tables all rows are always considered (independently of what users have filtered in the UI) unless you use the filter() formula. Otherwise you could not build consistent processes in Coda, because it would behave differently depending on the filters applied.

Hope this helps!

Pablo

1 Like
5

Hey Pablo, yes, this makes sense totally. Thank you.

6

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