Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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).
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).
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
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,
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²
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