MAX of Sum IF expression

[#1]

Hi all,

I'm new to QV and I'm trying to figure out how to write an expression calculating the the maximum of a SUMIF expression, without any luck.

For a certain range of dates I need to present the three largest positive and negative values (gross sent and gross received).

For instance, I would like to choose a month and then present the three largest daily sums. I guess what Im lookin for is some kind of aggregated function but I can't seem to get it right.

Any ideas?

Pls see examples attached.

Kind Regards,

Olle  

[#2]

Hi Olle,

check my example

[#3]

Thank you for your answer Dariusz,

however. My problem is that I first need to summarize the negative and positive values (separately) for each date selected. As per below:

SUM(IF(TransactionAmount<0,TransactionAmount))

SUM(IF(TransactionAmount>0,TransactionAmount))

After this is done, I need present the three largest/smallest sums.

Thanks in advance,

Olle

[#4 · Accepted solution]

try this:

[#5]

Perfect.

Thanks a lot for your help Dariusz!

Regards,

Olle

[#6]

Hi again,

Im pretty sure it worked just fine at first.

Then something happened, now when I open the qvf-file you attached above the min column always shows the same value as rank 1 & 2. Do you know what might have happened? I even restarted my computer and then downloaded the file from here again.

Pls find attached.

Rgds,

Olle

[#7]

I opened your attachment and i can see:

[#8]

Ok, must be something with my local settings.

Thanks!

[#9]

Strange ....

Check again and let me know