Under region i am showing profit(Avarage) and Order quantity(sum)
Please find attachement for more details
but after multiplying with AVG(profit)*sum(order qty)
am not getting expected result
The reason is that you set the AVG(Profit) for two decimal. For example, in West, it is 33.85. If you set it for six decimal. It will be 33.849032. If you times it with Sum (Quantity), you will get the expected result.
You can set the decimal through "Format".
Hope it helps.
I tried ,but no luck
Can you check my latest twbx
In your last version, the AVG (Price) is 61. However, the actual value is not 61. More exactly, it is 60.598000. If it times 202, the test is 12240.796.
Here I set AVG(Price) for 6 decimal and test for 3 decimal. Everything is as expected. What is your problem?
Retrieving data ...