I have a calculated field and I would like to have a totals calculated for the column. But under the data settings for the column I don't see the ability to add a column total like there is for a float field. Is there any way to do this?
If you are using a formula column please note there are some limitations
In tables with server-side processing formula columns cannot be used for grouping, filtering, and sorting. Basically, formulas are calculated only for the rows that are immediately visible; Therefore, it’s not possible to “know” the values for currently invisible rows. Please note that this also applies to the “Manual” tables, as they also use server-side processing by default. Also, of course, it is not possible to edit the cells generated by formulas in the editable tables.
Hi,
I have a calculated field and I would like to have a totals calculated for the column. But under the data settings for the column I don't see the ability to add a column total like there is for a float field. Is there any way to do this?
Thanks,
-Norm
Hi Norm
Thank you for reaching out to us.
If you are using a formula column please note there are some limitations
In tables with server-side processing formula columns cannot be used for grouping, filtering, and sorting. Basically, formulas are calculated only for the rows that are immediately visible; Therefore, it’s not possible to “know” the values for currently invisible rows. Please note that this also applies to the “Manual” tables, as they also use server-side processing by default. Also, of course, it is not possible to edit the cells generated by formulas in the editable tables.