Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In the list box I have years from 2000 to 2014.
If I select 2012 and 2013 the variance is showing for 2013 but it is showing 0 for 2012.
The logic I implemented is:
=if(RowNo(Total)=1,0,(count(Cloumn1)-above(count(Column1))) / above(count(Column1))
Post your sample app....
Your year keep as variable ( v_year )
apply calculation field as
For current year
if( your_year_field_name=v_year,value_of_field_name,0)
For Previous year
if( your_year_field_name=v_year-1,value_of_field_name,0)
Variance
if( your_year_field_name=v_year,value_of_field_name,0) - if( your_year_field_name=v_year-1,value_of_field_name,0)
Hope your this is solution.