min and max in chart

[#1]

Why does the following expression not work in a chart?

Sum(if(Year=Max(Year),Profit,0))-Sum(if(Year=Min(Year),Profit,0))

If have selected more than one Year

[#2 · Accepted solution]

Try Max(Total Year) and Min(Total Year) in place of Max(Year) and Min(Year).

Does this work? Why?

[#3]

It works! Thanks!