Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to Caluculate this ?
2012: Avg(12 month rollingavg) - 2011: Avg(12 month rollingavg)...
Hello
Use following expression:
Sum({<CalDate={">$(=addyears(max(CalDate),-1))<=$(=max(CalDate))"},CalYear=,CalMonth=,CalQuarter=>}Sales)
Regards
Use following expression:
Avg({<CalDate={">$(=addyears(max(CalDate),-1))<=$(=max(CalDate))"},CalYear=,CalMonth=,CalQuarter=>}Sales)
I don't understand what you're asking. Can you show us some sample data and an example of the calculation?