Skip to Content
0
Former Member
Feb 21, 2011 at 09:55 AM

Script Logic: change in numerator doesn't trigger calculation

30 Views

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