AGGR FUNCTION

[#1]

Hi folks!!

I´m building accountance acumulate reports and i´ve got year and month slider´s. On a pivot table I´ve got account as dimension and four expresion columns. The way I use this reports it´s as easy as select year and month to see how profit or lose has been acumulated by the company.

It´s works fine, but now I want to create a field on a multibox that provide me some new information. I want to clasify acumulate total (depending on month selected) by account as positive or negative. To get this I wrote:

=IF(AGGR(SUM({$<MONTH={"<=MONTH"}>} IMPORT), COMPANY, ACCOUNT)>0,'POSITIVE','NEGATIVE')

I think it´s easy, but somthing is wrong. As I told before, it´s essential for me to select year and month to get data. Should be my data filtered by month? Could it be the reason to make me lose my target?

Thanks in advanced, Fiber9906

PS. I´ve read interest things, but I didn´t feel they could be my solution.

[maneshkhottcpl]

Hi,

Please try this.

=IF(AGGR(SUM({$<MONTH={$"<=MONTH"}>} IMPORT), COMPANY, ACCOUNT)>0,'POSITIVE','NEGATIVE')

[#3]

Hi, thanks for your answer but it doesn´t work. It just give me 'negative' option to select. I review comas, $simbol, curly brakets,... and I think everything is ok. Any other ideas?

Thanks, Fiber9906

[maneshkhottcpl]

Hi,

Can u post me sample application with some data?

[#5]

I don´t know why my computer doesn´t let me upload this document. I will prepare you my data set and explaination what it´s happening.

Thanks Manresh

Fiber9906

[brenner_martina]

Hi,

best version is this:

=IF(AGGR(SUM({$<MONTH={"<=$(MONTH)"}>} IMPORT), COMPANY, ACCOUNT)>0,'POSITIVE','NEGATIVE')