Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
((sum({$<Year={"$(=MAX(Year))"}>} field)-(sum({$<Year={"$(=min(Year))"}>} field)))/(sum({$<Year={"$(=MAX(Year))"}>} field)))*100
((sum({$<Year={"$(=MAX(Year))"}>} field)-(sum({$<Year={"$(=min(Year))"}>} field)))/(sum({$<Year={"$(=MAX(Year))"}>} field)))*100
Thanks for you Answer
((sum({$<Year={"$(=MAX(Year))"}>} field)-(sum({$<Year={"$(=min(Year,2))"}>} field)))/(sum({$<Year={"$(=MAX(Year))"}>} field)))*100
Solution suggested by permula also would work, if user selects only two years from list box. for eaxmple user selects 2009 and 2011. it`ll give the comparison between 2009 and 2011. but incase user select 3 yrs like 2007,2009,2011 then perumal solution would give you the result for 2007 Vs 2011. but by using Max(Year,2) would return the 2009 second max value so as you required the you could compare 2009 Vs 2011.
hope this help you.
- Sridhar
Extremely helpful example!!! Thanx and congrats!!!