Page 1 of 1

Distribution variable factor (Fox Performance Issue)

PostPosted: Thu Aug 25, 2011 3:44 pm
by Yolanda
Hi guys and gals

I have to distribute an annual budget to each month of the year with variable distribution factors according to a combination of characteristics

AREA ORG_UNIT DIST_FACT
AAA XXX DF1
AAA YYY DF2
BBB ZZZ DF3
…



JAN FEB MAR APR MAY JUN JULY AGUS SEPT OCTB NOV DIC
DF1 : 1/12 1/12 1/12 1/12 1/12 1/12 1/12 1/12 1/12 1/12 1/12 1/12
DF2 : ¼ ¼ ¼ ¼
DF3 : 1/2 1/2

Now I have a FOX Formula that does the job but the performance is terrible for a huge AREA (I am reading 200 k registers so the formula creates 200000 * 12 = 2400000 aprox)

Can I pull this out with standard distribution functions?
Any other recommendations?

Thanks in advance Yolanda