How to calculate a cumulative column

[#1]

Hello,

Just started to work with V9 SR4 licence

Based on below data set , would like to know how to calculate M² Cumul , with same result as the last column calculated via export to excel !

PHASE	WO #	Workshop	M²	M² cumul
Total	Total	Total	Total	35 177,39
10.Photo interne	51853	En Attente	0,24	0,24	0,24
10.Photo interne	53619	En Attente	0,24	0,24	0,48
10.Photo interne	53633	En Attente	0,24	0,24	0,72
10.Photo interne	52919	En Attente	0,48	0,48	1,20
10.Photo interne	53054	En Attente	0,48	0,48	1,68
10.Photo interne	52659	En Attente	0,54	1,08	2,76
10.Photo interne	52663	En Attente	0,54	1,08	3,84

[Oleg_Troyansky · Accepted solution]

If you need to calculate it in the Chart (like a Straight Table), you can either mark the Expression with "Full Accumulation" (on the "Expressions" Tab), or use function above(column(N)) to add the value from the previous line - just be careful with the first line, because in the first line function above() returns a null(). The following should work:

RANGESUM( ABOVE( Column(3), Column(2))

Function RANGESUM will add the two values together, while replacing nulls with zeros. Column(3) is the accumulated column, so you use the value from the line above and adding to it the current value of the Column(2).

[#3]

Many thanks for your immediate answer. I have tried a lot of things based on your advice but without success

I have attached a cumul.qvw file to help in the resolution

could you have a look at it to identify the right setup

thanks in advance

[#4]

Hi

Part of your problem there was that you had included M2 as a dimension, which has an impact on the RangeSum and full accumulation aspects, so the example I have attached moves M2 into the expressions list.

I included two expressions using RangeSum as per Oleg's suggestion, both of which are working fine.

Also..... in your load script there is no closing ]; at the end of your LOAD INLINE statement, I'm not sure of the impact of this but it might be unpredictable so I added that in.

Regards,

[#5]

Hello ,

thanks for your reply

Again , I have not been able to reproduce just because when adding a new dimension, it is no more working.

In fact i am just not understanding the syntax of this expression.

My need is to do a list of record with a CPT as a unique key but not being the first one for a sort of data and with a lot of dimensions and with a cumul of a numeric field : list of work orders sorted by priority id, date of expedition , ... and with a cumul at line level of M²

[martino]

Hi NigelWest,

Do you by that mean that it is not possible to make an Accumulated Column if there are more than one Dimension in the table?

Best regards

Martin