topic Problem with Total in Calculation in App Development

Problem with Total in Calculation

bmac1 — Mon, 12 Aug 2024 18:59:02 GMT

Hi I have an expression in the front-end which compares two expressions.

If the rangemax() of these two expressions is equal to 0, we show 1 in the new column.

Else we take the rangemax() of the two expressions and show the greater value.

If(
RangeMax($(expA),$(expB))=0,'1',
RangeMax($(expA),$(expB))

What we are seeing is that in the total of this expression, the '1' isn't being counted into the total for the rows where the first condition is met.

Any ideas?

Re: Problem with Total in Calculation

Digvijay_Singh — Mon, 12 Aug 2024 19:59:57 GMT

Pl share the complete expression, do you have anything before If( statement.

Do you really need if condition here? isn't it same as RangeMax($(expA),$(expB),1)?

If both expA and expB are <=0, the final value will be automatically '1' in above expression Ishared as '1' is higher than rest of the two.

Let me know if I am missing something or misunderstood the need here.

Re: Problem with Total in Calculation

rwunderlich — Mon, 12 Aug 2024 23:37:48 GMT

On the total line, the expression is being run over all the data, so your result makes sense. If you want to add the 1's (which are really zero values) from the previous lines, for this expression change the Totals Mode from "Auto" to "Sum".

-Rob