Apex Code Development You need to sign in to do that
Don't have an account?
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...!!!
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...!!!
Please check with below thread from the forums community with similar issue and suggested workaround.
- https://developer.salesforce.com/forums/?id=906F00000008ue0IAA
Mark this as solved if it's resolved.Regards,
Nagendra.