topic Sum of rows in pivot table in App Development

Sum of rows in pivot table

sunnybi — Mon, 18 Aug 2025 14:51:37 GMT

Hi everyone,

Hope y'all have a nice summer time .

I got an issue with a pivot table . As you can see in the table below on the 2nd line , the total is uncorrect.

The expression return the correct values . the pivot table got only 1 dimension 'week_number'

I tried : sum(aggr ( expression, week_number)) and the total is uncorrect.

Basically , the expression is : if column(1) < column(4) then column(4) - column(1) else 0 .

Feel free to ask any question.

Thank you for your help !

Re: Sum of rows in pivot table

Oleg_Troyansky — Mon, 18 Aug 2025 14:55:50 GMT

Hi there,

I don't think that you can use the Column() function in combination with AGGR() - you probably need to repeat the expressions for columns 4 and 1. Also, you can simplify your formula a bit - instead of asking IF..., use Rangemax():

Rangemax(A-B, 0)

If A < B, then zero will be the max.

Cheers,

Oleg Troyansky

Re: Sum of rows in pivot table

sunnybi — Tue, 19 Aug 2025 08:08:12 GMT

1000 thanks to you