6 Replies Latest reply: Nov 9, 2015 11:02 AM by Aidan O Reilly

# Above() or below() functions

Hi there

I want to create a chart as per the below, I have the user, date and the volume per day.

But in the MTD column I need to have 61+71 in row 2 for example.

In row 3 its the sum of 71+61+75 and so on.

Is this possible?

I have tried above and below functions but cannot seem to achieve this.

Thanks,

Aidan

 User Date Volume Total MTD User 1 01/11/2015 71 71 User 1 02/11/2015 61 132 User 1 03/11/2015 75 207 User 1 04/11/2015 56 263 User 1 05/11/2015 55 318 User 1 06/11/2015 74 392
• ###### Re: Above() or below() functions

Try with

=RangeSum( Above( Sum(VolumeField), 0, RowNo() ))

• ###### Re: Above() or below() functions

Or may be this:

=RangeSum(Above(TOTAL Sum(VolumeField), 0, RowNo(TOTAL)))

• ###### Re: Above() or below() functions

Hi Sunny

That's great, only thing is if I wanted it to reset at each new row fro example below;

 User Date Volume Total MTD User 1 01/11/2015 71 71 User 1 02/11/2015 61 132 User 1 03/11/2015 75 207 User 1 04/11/2015 56 263 User 1 05/11/2015 55 318 User 1 06/11/2015 74 392 User 2 01/11/2015 40 40

AIdan

• ###### Re: Above() or below() functions

That's why I left out the TOTAL qualifier.

• ###### Re: Above() or below() functions

Perfect thank you

• ###### Re: Above() or below() functions

Hi,

you can use the following expression in your query: