Above() or below() functions

[#1]

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

[swuehl · Accepted solution]

Try with

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

[sunny_talwar]

Or may be this:

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

[#4]

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

Thanks again for your help

AIdan

[Anonymous]

Hi,

you can use the following expression in your query:

LOAD ...

[Volume] + if(isnull(Peek(acc_volume, -1)), 0, Peek(acc_volume, -1)) as acc_volume

from ...;

[swuehl]

That's why I left out the TOTAL qualifier.

[#7]

Perfect thank you