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