incorrect result when 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):
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 |
| 120,747,545.85 |
But when i exclude the ledger currency conversion rate from the analysis, its giving a different amount for revenue amount in ledger currency column: 113988725.4
Version (include the version you are using, if applicable):
I am using Project Billing Revenue OTBI
Code Snippet (add any code snippets that support your topic, if applicable):