How to avoid aggregate in expression ?

[paulyeo11]

‌Hi All

In order to solve my problem , I need to make use of aggregate function in my expression.

but i am not able to completely solve it. For example I can get YTD amount but I am not able get the LY YTD amount correct.

My question is it is possible using aggregate in partial reload script , this way I can avoid it in expression . Can some one advise me ?

PAul

[swuehl · Accepted solution]

I have not understood what your issue is, but you should be able to use a GROUP BY clause in a LOAD statement with aggregation functions also in a partial reload (using the ADD or REPLACE LOAD prefix).

[paulyeo11]

‌Hi Stefan

thank you for your sharing , I will try it .

PAul