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"
0