You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!