calculated measure by multiplying 2 columns
Summary:multipying revenue amount with ledger amount is giving incorrect results.
Content (please ensure you mask any confidential information): project billing revenue work area
External Revenue Amount in Bill Transaction Currency | Ledger Currency Conversion Rate | Revenue Amount in Ledger Currency |
---|---|---|
13029087.65 | 0.89855 | 11707286.71 |
-128714461.1 | 0.90342 | -116283218.5 |
28960060 | 0.92111 | 26675400.87 |
129016060 | 0.92413 | 119227611.5 |
83883929.08 | 0.94679 | 79420465.21 |
126174675.6 | 120747545.9 |
If i include conversion rate it works well but see below if i exclude conversion rate in analysis then I am getting a different result :
113988725.4 which is different from 120747545.9
I am using the calculated measure by simply multiplying
External Revenue Amount in Bill Transaction Currency *
Ledger Currency Conversion Rate
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):