Regarding the total sum of calculated filed in the table

Question & Answer
, , , , ,
1

Good day, All

I was confused as to why the total sum of the calculated field was wrong. Actually, it has to be 31,294 in total, not 31,267 in a box in red.

image

I think because of the calculated formula, the wrong total sum happened.
Here is the each of column’s formula. If there is anything I have to fix, please let me know. :slight_smile:

[Formula]
a: sum(net) / (sum(sale_price)/1.1)
b: sum(net) / (sum(dc_sale_price)/1.1)
c: b - a
d: c * 0.7
e: b - d
f: e * sum(dc_sale_price)/1.1

Best regards,
Boram

2

Hi @iamboram ,

How is the expected result computed ? Is it by summing up above rows?
I believe since your calculation has different numerator and denominator aggregation, the total will be powered with the same formula
e * sum(dc_sale_price)/1.1 instead of sum of above rows.

Can you try calculating using the formula on totals of the dependent field and see if that is a match ?

Since I have less context on your use case, it will be difficult to validate the formula used.

Thanks,
Prantika

3

Hi, @prantika_shinha,
Thank you for your answer.

I found out the issues on my own.
Because of the decimal place, the result showed up like that.
After I used ‘round-function’, I solved the issues.

Thank you!

Best regards,
Boram