Hi Guys,
I have the following table…
ID VALUE
1 100
2 -20
3 70
How can I add a VIRTUAL COLUM to do a CASH FLOW, like that
ID VALUE CASHFLOW
1 100 100
2 -20 80
3 70 150
SO, the CASHFLOW sums previous ids…
Based on the example you gave, you could use the sum and select formulas.
You can use something like SUM(SELECT(Table[VALUE], ([ID] <= [_THISROW].[ID])))
initial value
ANY(
SELECT(
table[column],
([_ROWNUMBER] = MAX(table[_ROWNUMBER]))
)
)
FORMULA
Column 3 + Column 2
User | Count |
---|---|
35 | |
31 | |
30 | |
20 | |
17 |