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

Calculation: Correct input, wrong output. why?

Q&A

Max April 17, 2023, 7:05pm 2

It has to do with rounding.

1 Like

Topic		Replies	Views
Rounding issue: Incorrect result when dividing in a calculated field Q&A calculations	3	1176	March 10, 2023
QS is doing the math wrong, Significant digit issue? Increase precision of calculated fields? Q&A feature-request , calculations , Business-Intelligence-Engineer	2	21	October 1, 2025
Wrong calculation? Q&A Business-Intelligence-Engineer	5	163	June 26, 2024
Multiply and division in quicksight Q&A calculations	1	805	July 24, 2023
Regarding the total sum of calculated filed in the table Q&A analysis , dataset , calculations , Business-Intelligence-Engineer , tables	2	76	June 5, 2024

Calculation: Correct input, wrong output. why?

Related topics