Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to make a table with the total billed value on YearPeriod x
this is a start, i need to translate this afterwards in payed days in adition to the costs (work in progress)
DC | YearPeriod | total | row below | WANTEDVALUE | |
europe | Total | -17.879 | - | ||
europe | 2013012 | -1.198 | 1.614 | -17.879 | C3+E4 |
europe | 2013011 | 1.614 | 3.311 | -16.681 | C4+E5 |
europe | 2013010 | 3.311 | 279 | -18.296 | C5+E6 |
europe | 2013009 | 279 | 1.457 | -21.607 | C6+E7 |
europe | 2013008 | 1.457 | 7.752 | -21.885 | C7+E8 |
europe | 2013007 | 7.752 | -31.095 | -23.342 | C8+E9 |
europe | 2013006 | -31.095 | 0 | -31.095 | C8+E10 |
how can i create Wanted Value?
rangesum
(
below(
sum( {$<
YearPeriod= {">=1900001"}
>} WIP)*-1,
0,
noofrows()-rowno())
)
found it out, solution was on : noofrows()- rowno()
rangesum
(
below(
sum( {$<
YearPeriod= {">=1900001"}
>} WIP)*-1,
0,
noofrows()-rowno())
)
found it out, solution was on : noofrows()- rowno()