Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, i have a column like the one on the left and i need it like the one on the right:
today()-max(Giorno_prec) | Delta |
101 | 101 |
105 | 4 |
111 | 6 |
116 | 5 |
119 | 3 |
120 | 1 |
124 | 4 |
135 | 11 |
137 | 2 |
138 | 1 |
How can i calculate Delta?
thanks
Hey there,
The correct formula is something like this:
if(isnull(Sum(F1) - Above(Total Sum(F1))), Sum(F1), Sum(F1) - Above(Total Sum(F1)))
Substitute F1 to you field.
Please, see the results in the attached file.
Best regards,
MB
My field was an expression, it was today()-max(Giorno_prec), if i put this instead of F1 it says "Error in expression" how can i fix it?
Try this
RangeSum( (Today() - Max(Giorno_prec)), -Above(Today() - Max(Giorno_prec)) )
Or this
RangeSum( (Today() - Max(Giorno_prec)), -Above(TOTAL Today() - Max(Giorno_prec)) )
This worked for an issue I was having! Just make sure you add both expressions to the chart and everything will calculate as needed. Thank you!