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

not accurately summing

Summary:


Content (please ensure you mask any confidential information):

Hi

We need to sum one dimension based on its value, adding all level 0 members of other dimensions.

"0050" is a functional area dimension member, which needs to be summed up, and it needs to be passed to a member in the account dimension called total revenue. Wrote a script like below, its not getting summed up accurately.


Fixparallel (4,{RTP_Entity},@relative("Input Currencies",0))

Fix ("fy25",@relative("yeartotal",0))

FIX ({RTP_Version},"No Cost Center",{RTP_Scenario},
"No profit center","no functional area","no segment",
"no future","OFS_Calculated")

"Total Revenue_D_MAS"

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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