How are CRM Cycle Plan calls calculated?
The Cycle Plan calculation considers calls that are between the Start Date and End Date of the Cycle Plan.
The call Territory_vod__c field must match the Cycle Plan Territory. If the user has access to calls that do not match the Cycle Plan Territory, the calls are not counted in the calculation.
The calculations for the individual targets are abbreviated as shown below:
- This data is calculated through an apex job.
- The Veeva Message CALC_CYCLE_PLANS_ACTUAL can be customized.
- OOB CALC_CYCLE_PLANS_ACTUAL = (Status_vod__c = 'Submitted_vod' or (Status_vod__c = 'Saved_vod' and Call_Date_vod__c <=TODAY))
- Manually entered or data loaded with the cycle plan by the customer.
- This data is calculated through the Cycle Plan Apex job.
- The Veeva Message CALC_CYCLE_PLANS_SCHEDULED can be customized.
- OOB CALC_CYCLE_PLANS_SCHEDULED = (Status_vod__c = 'Planned_vod' or (Status_vod__c = 'Saved_vod' and Call_Date_vod__c >today))
- This is a formula field which is based on Planned and Actual Calls.
- Out-of-the-box (OOTB) formula for Remaining_vod__c: IF(AND(ISBLANK(Planned_Calls_vod__c),ISBLANK(Actual_Calls_vod__c)),0 ,IF(ISBLANK(Actual_Calls_vod__c) ,Planned_Calls_vod__c , IF(ISBLANK(Planned_Calls_vod__c ),0 , IF((Planned_Calls_vod__c -Actual_Calls_vod__c )>=0,Planned_Calls_vod__c -Actual_Calls_vod__c ,0))))
Remaining Schedule (Rs):
- This is a formula field based on Planned, Scheduled and Actual calls.
- Out-of-the-box (OOTB) formula for Remaining_Schedule_vod__c: If(Planned_Calls_vod__c - Scheduled_Calls_vod__c - Actual_Calls_vod__c > 0, Planned_Calls_vod__c - Scheduled_Calls_vod__c - Actual_Calls_vod__c, 0)
CRM Help Documentation: Cycle Plans
Send us your feedback: We're always looking for advice to help improve our Knowledge Base! Please let us know if this article was helpful or provide feedback on how we can improve your experience here.