[image] My calculated field (test) is this formula: (sum({PLAN_RSRC_USAGE},[{BATCH_ID}])/sum({PLAN_RSRC_QTY_ROUTING_UOM},[{BATCH_ID}]))* sum({ACTUAL_QTY_IN_ROUTING_UOM},[{BATCH_ID}]) from the image above, the formula is (A/B)*C. (55.14/17920)*17920 If you calculate it with any calculator the …

It has to do with rounding. [image] Rounding issue: Incorrect result when dividing in a calculated field Question & Answer Hi @Elope - Thank you for raising this issue here. You can use this as a workaround. ({weight}*1000)/(1000^2) Example: [image]

Amazon QuickSight Community

Calculation: Correct input, wrong output. why?

Question & Answer

Max April 17, 2023, 7:05pm 2

It has to do with rounding.

1 Like