Hi guys, I need an advice: I have Script logic with numerator and denominator. However, when I change numerator, script logic doesn't work, while when I change denominator it works just fine. Here is a code
*WHEN P_ACCT *IS "PAC30105" *REC(EXPRESSION=([P_ACCT].[PAC30108], [COSTCENTER].[CCN2]) / [P_ACCT].[PAC30105], WORKSHOP_LINE= "WSL2", PARTNER = "PRN2", STOCK_CATEGORY = "STC2", SALE_PROJECT = "SLP2", P_ACCT="PAC30306") *ENDWHEN
same goes with
*WHEN P_ACCT *IS "PAC30105" *REC(EXPRESSION=([P_ACCT].[PAC30108], [COSTCENTER].[CCN2]) / %VALUE%, WORKSHOP_LINE= "WSL2", PARTNER = "PRN2", STOCK_CATEGORY = "STC2", SALE_PROJECT = "SLP2", P_ACCT="PAC30306") *ENDWHEN
same goes with
*WHEN P_ACCT *IS "PAC30105", "PAC30108" *REC(EXPRESSION=([P_ACCT].[PAC30108], [COSTCENTER].[CCN2]) / [P_ACCT].[PAC30105], WORKSHOP_LINE= "WSL2", PARTNER = "PRN2", STOCK_CATEGORY = "STC2", SALE_PROJECT = "SLP2", P_ACCT="PAC30306") *ENDWHEN
and same goes with
*XDIM_MEMBERSET P_ACCT=PAC30105,PAC30108 *WHEN P_ACCT *IS "PAC30105" *REC(EXPRESSION=([P_ACCT].[PAC30108], [COSTCENTER].[CCN2]) / [P_ACCT].[PAC30105], WORKSHOP_LINE= "WSL2", PARTNER = "PRN2", STOCK_CATEGORY = "STC2", SALE_PROJECT = "SLP2", P_ACCT="PAC30306") *ENDWHEN
Thank you for you support