Forum Stats

  • 3,770,167 Users
  • 2,253,079 Discussions
  • 7,875,357 Comments

Discussions

Question on Reducing Calculation Time on Script

Zut Alors
Zut Alors Member Posts: 167 Blue Ribbon
edited Jan 28, 2020 8:21AM in Planning and Budgeting

Greetings,

I have a calc script which takes 50 mns to run and would like to reduce the time it takes to run by about half.  I've tried various things such are adding calcparallel and calctaskdim, which helps a bit.  Below is a simplified version of the script.

The issue arises when running this script for all 50 states (plus some additional entries for international regions) - basically I need to sum up all states/regions into geo_combined and then perform some additional math (not shown here).  Just the @sum() adds a lot of time to the calculation.  Any input to improve on this simple calc is greatly appreciated...  Thank you.

fix( @relative( "year total", 0), working, @relative(account, 0 ) )

fix( @relative("cost center", @list( "geo_fl", "geo_ark", "geo_alaska", etc )

     "geo_combined" = @sum( "geo_fl", "geo_ark", "geo_alaska", etc) * some_math...

endfix

endix

regards,

cl

Tagged:

Best Answer

Answers