summing does not occur as expected
Summary:
Content (please ensure you mask any confidential information):
Hi
I need to get the sum of all the level 0 accounts, level 0 cost centers, where a member is tagged as "Room sales_FA" in another dimension called functional area. and pass it to an account called "Room sales_d_mas"
We are getting the correct summation till Apr to sep. where, it is two different accounts. But from october onwards, it is only taking the value of 50800160 account, ignores the value of 50800080.
Below is the script i use.
FIX ({RTP_Version},{RTP_Scenario},@relative("Total Cost Center",0),
"No Future","No Profit Center")