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

calculated measure by multiplying 2 columns

edited Feb 25, 2025 8:01AM in Enterprise Data Management 2 comments

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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