Skip to Content
0
Oct 06, 2014 at 05:20 AM

Script multiplying values wrongly

17 Views

Hello All,

I am getting value multiplied by 2 in below script logic:

*XDIM_MEMBERSET MODEL=%ASTOCK1%

*XDIM_MEMBERSET SLSACCOUNT=SALES_UNIT, SAIR_REBATE_PER_UNIT,SMIR_REBATE_PER_UNIT,BMIR_REBATE_PER_UNIT,BIR_REBATE_PER_UNIT,ABR_REBATE_PER_UNIT,DCR_REBATE_PER_UNIT

*XDIM_MEMBERSET CUSTOMER=<ALL>

*XDIM_MEMBERSET CHANNEL=<ALL>

*XDIM_MEMBERSET AUDITTRAIL=INPUT

*WHEN MODEL.CALC_QTY_DRIVEN_ACCT

*IS <> "N"

*WHEN SLSACCOUNT

*IS SALES_UNIT

*REC(EXPRESSION=[SLSACCOUNT].[SAIR_REBATE_PER_UNIT]*[SLSACCOUNT].[SALES_UNIT]*-1, SLSACCOUNT="SAIR_REBATE_CALC")

*ENDWHEN

*WHEN SLSACCOUNT

*IS SAIR_REBATE_PER_UNIT,SMIR_REBATE_PER_UNIT,BMIR_REBATE_PER_UNIT,BIR_REBATE_PER_UNIT,ABR_REBATE_PER_UNIT,DCR_REBATE_PER_UNIT

*REC(EXPRESSION=[SLSACCOUNT].[SAIR_REBATE_PER_UNIT]*[SLSACCOUNT].[SALES_UNIT]*-1, SLSACCOUNT="SAIR_REBATE_CALC")

*ENDWHEN

*ENDWHEN

*COMMIT

I have tried posts:

but not getting correct value. Could anyone please help me in this?

Beat Regards,

Deepak Palsaniya