Difference between values of the same column

[matbelli]

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

[miguelbraga]

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

[matbelli]

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?

[sunny_talwar]

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))
)

[amskeith]

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!