+ Start a Discussion
Sushma  RamakrishnanSushma Ramakrishnan 

Rolling 12 Months Report in Salesforce

Hi All,

I am trying to create a Rolling 12 Months Report in Salesforce.
The formula i have used is as below :
IF( PO_Approval_Date__c <= Vendor__r.Current_CY_As_Of_Date__c -365 , 1, 0)

PO_Approval_Date__c : is a Date field -> Date of Spend.
Vendor__r.Current_CY_As_Of_Date__c : is a Date field -> Max of Date as per the data uploaded in Spend object.

What is basically want to achieve is : For eg: If I have loaded data in my Spend object till Nov2016.Then in 12 months rollling report itn should show me data from Nov 2016 to Dec2015.
Currently by using the above formula its showing me data till Nov2015.
Please help me correct this.

Thanks for All & Any Help in Advance...!!!
NagendraNagendra (Salesforce Developers) 
Hi Sushma,

Please check with below thread from the forums community with similar issue and suggested workaround. Mark this as solved if it's resolved.

Regards,
Nagendra.