I need to multiply following two records and generate a new record with Account as "CASHDISC".
and for that I wrote the following code in script logic but it's not working and always returning 0 amount for account CASHDISC.
*XDIM_MEMBERSET Account = GROSSSALES *XDIM_MEMBERSET Brand = %Brand_SET% *WHEN ACCOUNT *IS * *REC(EXPRESSION = %VALUE% *([ACCOUNT].[CASHDISCPCT],[BRAND][NO_BRAND]), ACCOUNT=CASHDISC) *ENDWHEN *COMMIT
Please suggest how to make it work.