SUMIFS in LOAD script

[#1]

Hi,

I have a large straight table with a lot of SUM IF formulas like the below, which makes it very slow when recalculating.

Im thinking about making the calculations in the script instead. Any idea how I could implement it?

Thanks in advance,

Olel

SUM({<[FLOW TYPE]= {'XXX'}>} IF([FLOW EFFECTIVE DATE]<=DATE and [FLOW MATURITY DATE]>= DATE,AMOUNT))

[#2]

Two identical while loads

Hi Gysbert.

Any ideas?

I've created another post for this one. Pls see link above.

Regards,

Olle