Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good morning,
i have a field with cumulative sums for month..
like this:
Month, value
1 10
2 40
3 50
4 70
i woul like to create another field with the exact amount, so:
month_new value
1 10
2 30
3 10
How should define it?
Check out the PREVIOUS command. Something like:
(Value - Previous(Value) ) AS ExactAmount
hi,
if its in table function, use below expression in measures:
=Column(2)-Above(Column(2))
Ksrinivasan
Hi @Carlaf_93 , please check this littele script :
A:
LOAD * INLINE [
Month, value
1, 10
2, 40
3, 50
4 , 70
];
B:
Load
Month,
if(recno()=1, value, value - previous(value)) as value2
Resident A;