Analytics Software

Hi,

I am new to Essbase and looking forward for your help in order to develop the below scenarios.

First one
-------------
I need an essbase function that calculates the average of the last three months. so if i am in Apr the value would be the average of JAN,FEB and MAR, i reviewed the @MOVAG but the problem is that it includes the month i am currently calculating in the calculation.

@MOVAVG Sales of APR = MOVAVG (Sales,3) returns the avg of APR,MAR and FEB, how can i work on this to return the required output which is supposed to be JAN,FEB and MAR


second one
------------------
I am looking for a function to calculate the last 18 months of an element.

I used the MDSHIFT to get the values of one year back then the PRIOR function to get the value of the last 6 months, but the issue is MDSHIFT returns a value but the input of PRIOR is a data element.

Regards,