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