Last 6 months data

[Anonymous]

Dear All

I have a requirement where I need to calculate average of last 6 months sales.

Example:  If we are in December we need to calculate average from June to November..

In Jan,  from July to Dec and so on.    Kindly help to achieve this possibility

Thanks & Regards

Chintan Gala

[Anonymous]

Dear Vineeth

It shows expression OK,  but later shows error as ')'  expected.

Thanks & Regards

Chintan Gala