Skip to Content
0
Former Member
Dec 09, 2011 at 05:05 AM

RUNALLOCATION problem with FACTOR=USING/TOTAL

98 Views

Hi guys!

I have accounts: A = 100.00 and B = 0.00, B is parent node for B01,B02: B01 = 0.00 B02 = 0.00

I need: B = 100.00 (from A) (B01 = 50.00, B02 = 50.00) (Other question is how can I get something like B01 = 30, B02 =70 etc.) So I use code:

*RUNALLOCATION 
*FACTOR=USING/TOTAL
*DIM X_ACCT WHAT=A;WHERE=BAS(B);USING=<<<;TOTAL=<<<
*DIM P_TIME WHAT=2011.JAN.01;WHERE=<<<;USING=<<<;TOTAL=<<<
*DIM RPTCURRENCY WHAT=USD;WHERE=<<<;USING=<<<;TOTAL=<<<
*DIM P_ENTITY WHAT=XXX;WHERE=<<<;USING=<<<;TOTAL=<<<
*DIM CATEGORY WHAT=XXX;WHERE=<<<;USING=<<<;TOTAL=<<<
*ENDALLOCATION
*COMMIT

and get warning: divided by zero in Allocation (B = 0.00 (B01 = 0, B02 = 0)

when I "remove"

*FACTOR=USING/TOTAL

and run script I get B = 200.00 (B01 = 100.00, B02 = 100.00)

After that I run script again with

*FACTOR=USING/TOTAL

and get correct result B = 100.00 (B01 = 50.00, B02 = 50.00)

What is wrong? How can I fix it? I don't want run script twice without and with FACTOR

Regards,

Maxim