Yearly Average Balance Script Optimization

@CHILDREN

Summary

Yearly Average Balance Script Optimization

Content

Hi -

This script was written to calculate our yearly average balance. The script takes forever to run-

Any suggestions on how to optimize it?

SET CALCPARALLEL 4;

SET MSG SUMMARY;

VAR

JanDays = 31, FebDays = 28, MarDays = 31, AprDays = 30, MayDays = 31, JunDays = 30,

JulDays = 31, AugDays = 31, SepDays = 30, OctDays = 31, NovDays = 30, DecDays = 31

;

FIX("Actual", "Final", &CurrYr, &CurrMth, @CHILDREN ("BALSHT"))

FIX(@RELATIVE("PBLOB", 0))

YAB(

IF(@ISMBR("JUL"))

"YAB" =

(

("JAN"->"MAB" * JanDays) + ("FEB"->"MAB" * FebDays) + ("MAR"->"MAB" * MarDays)

+ ("APR"->"MAB" * AprDays) + ("MAY"->"MAB" * MayDays) + ("JUN"->"MAB" * JunDays)

+ ("JUL"->"MAB" * JulDays)

)

/ (JanDays + FebDays + MarDays + AprDays + MayDays + JunDays + JulDays);