summing does not occur as expected — Cloud Customer Connect
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

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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