Skip to Content
0
Aug 29, 2018 at 08:12 PM

Script logic not working

81 Views

Hi,

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.

Regards,
Deepti

Attachments

test-2.jpg (10.8 kB)