Script doesnt work 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

Script doesnt work as expected

edited Mar 4, 2025 5:15AM in EPM Platform and Freeform 2 comments

Hi

we want the aggregation of a different dimension

eg

row 6 and 7 needed to be summed up in row 11

ie where ever the functionl area = Room Sales_FA it need to summed to Room Sales_d_Mas

the rule is as follows

________________________________________________________________________________________________

FIX ({RTP_Version},{RTP_Scenario},@relative("All Cost Center",0),
"No Profit Center",@relative("All SAP accounts",0),"No Segment")

"No Future"
(
if("Room Sales_FA" <> #missing)
"Room Sales_D_MAS"->"No Cost Center"->"No Functional area"=
"Room Sales_D_MAS"->"No Cost Center"->"No Functional area" +
"Room Sales_FA";
endif;

)

ENDFIX

________________________________________________________________________________________________

The result we get from the above script is Row number 6 has been multiplied by 2

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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