Skip to main content
spencer_engel
spencer_engel
Expert ⭐️
April 25, 2017
Question

Overdue CTA vs. Closed Overdue CTA

  • April 25, 2017
  • 3 replies
  • 114 views
When recently helping a customer put together a report on overdue CTAs, we discovered that the "Overdue" field on the Call to Action object includes CTAs that are due today, whereas the "Closed Overdue" field only includes CTAs that have been closed after their due date. 

So, for example, if I were to close a CTA that is due today, 4/25/17, and report on it, that CTA would show up as "Overdue" but not as "Closed Overdue."

This got a little confusing because my customer was trying to track both closed overdue CTAs and currently overdue open CTAs in the same report (we ended up splitting this into two reports). 

Can anyone help explain the distinction here? Thanks!

    3 replies

    sai_ram
    sai_ram
    Expert ⭐️⭐️
    April 26, 2017
    Hi,

    Below is the distinction between both fields .
    Closed Overdue : IF( JBCXM__ClosedDate__c > JBCXM__DueDate__c , TRUE,FALSE)
    Overdue : IF( JBCXM__DueDate__c < TODAY() , TRUE, FALSE)

    Thanks,
    -SaiRam
    vadim_matusovskiy
    vadim_matusovskiy
    Contributor ⭐️⭐️
    April 27, 2017
    Hi Sai,

    In this case, how would the report Spencer outlined to be done? The Overdue : IF( JBCXM__DueDate__c < TODAY() , TRUE, FALSE) rule should exclude today, right?

    Thak you
    nitisha_rathi
    nitisha_rathi
    Expert ⭐️⭐️
    April 28, 2017
    Hi,

    If CTA with due today is closed, that CTA should not show up as "Overdue" or "Closed Overdue". It is working fine in my org, if you face this issue again please send us the screenshot and we will try to debug it.

    Thanks,
    Nitisha
    Terms & ConditionsAccessibility statement