Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I need to find the difference of same month different year data.
i.e 2012 Feb value is 2000
2011 feb value is 1300
Desired value is 700
Is there any ways I can work on this through expression? It will automatically calculate the difference of 3 years data without any user input.
This is my code
(Sum({<Soldier_Class_Name = {'L'},Derived_Status = {'THIP'},Unlocode_Port_Of_Sleeping= {EE*'}>} TEU)
/Before( Sum({<Soldier_Class_Name = {'L'},Derived_Status = {'THIP'},Unlocode_Port_Of_Sleeping= {'EE*'}>} TEU) , 12)*100))-100
However, it will display all the values even if it is null value ( i have checked surpress value etc)
Therefore my question is, is there any code i can use to substitute the code, before?
Thanks
anybody....