Multiply and division in quicksight

[Moniksd]

Hi team,

I am trying to multiply the number and then divide. I am getting wrong results.
Example : raised issue 5334000000 and sales 506773840 where i will be multiplying issues with 10,00,000.
= issues * 1000000 / sales

Results should be 10.525. I am getting a different output in quicksight. Can you please help me !

[andres007]

Hello @Moniksd,

Welcome to QuickSight Community!

I have tried the calculation and it works as expected, in excel

Then I used this sheet to create a dataset and created a calculated field called qs_results and got the same number.

Kind regards,
Andres.