Skip to Content
0
Nov 18, 2012 at 12:18 PM

Evaluating value before allocation

16 Views

Hi,

BPC 7.5 NW - Script logic

I have the following script:

.....

*FOR %CUSTOMER2% = %CUSTOMER% AND %MODEL2% = %MODEL%

*FOR %SOURCE2% = %SOURCE%

*RUNALLOCATION

*DIM TIACCOUNT WHAT=PRICE; WHERE=PRICE

*DIM P_MONTH WHAT = %DUMMYMONTH%; WHERE=BAS(%BYEAR%.TOTAL)

*FACTOR=1

*ENDALLOCATION

*NEXT

*NEXT

*COMMIT

As you can see, it basically takes a value that the user keyed for a dummy month and spreads it across all months. it does the action for various combinations of dimension values that are in variables.

My question is - I want to verify that the amount I am about to spread is different than 0 before I spread it. I though of adding a *SELECTCASE right after the second *FOR statement but I got an error when I run it through the data manager (validation was OK).

Any ideas about how to do this?

Thanks,

Avihay