[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]

Thanks, this solved the issue. using round() did not. I hope this gets resolved by Amazon rather quickly.

Calculation: Correct input, wrong output. why?

Q&A

Max April 17, 2023, 7:05pm 2

It has to do with rounding.

Topic		Replies	Views
Rounding Issue Q&A developer , quick-sight	7	130	October 14, 2026
Rounding issue: Incorrect result when dividing in a calculated field Q&A quick-sight , calculations	3	1217	March 10, 2023
QS is doing the math wrong, Significant digit issue? Increase precision of calculated fields? Q&A feature-request , quick-sight , calculations , Business-Intelligence-Engineer	2	65	October 1, 2025
Wrong calculation? Q&A quick-sight , Business-Intelligence-Engineer	4	218	June 24, 2024
Multiply and division in quicksight Q&A quick-sight , calculations	1	844	July 24, 2023

Calculation: Correct input, wrong output. why?

Related topics