Skip to main content
heather_hansen
heather_hansen
VIP ⭐️⭐️⭐️⭐️⭐️
June 29, 2016

Age field in Reports

  • June 29, 2016
  • 4 replies
  • 73 views
I'm trying to create a report to show CTAs that are in a certain status, and I want to also show the Age of those CTAs, however it looks like the Age calculation is based off of the Created Date and not the Due Date. Do I have a way to change that, and if not, there should be another field for Days Past Due Date (or I'd like to be able to do that calculation)

      4 replies

      marie
      marie
      Gainsight Employee ⭐️⭐️
      June 29, 2016
      Hi Heather, you can't change the Age calculation but you can create a new for Days Past Due.

      Create a new formula field (that returns a number) on the CTA object and use this formula:
      TODAY() -  JBCXM__DueDate__c

      If we are not past the Due Date yet then the number will be negative.
      heather_hansen
      heather_hansenAuthor
      VIP ⭐️⭐️⭐️⭐️⭐️
      June 29, 2016
      Thanks, Marie! Since I don't have SF Admin privileges, I was hoping for a solution in GS. 🙂 I'll get my IT Team to implement the above in the meantime. I appreciate it!
      sudarshan_vig
      sudarshan_vig
      Contributor ⭐️⭐️⭐️⭐️⭐️
      June 30, 2016
      Hello Heather, Thanks for your input. For now you can go ahead with what Marie has suggested. In the meantime I am working on trying to incorporate formula fields in Reporting. That ought to solve your problem the way you need it.
      phani_kumar
      phani_kumar
      Gainsight Employee ⭐️⭐️
      February 5, 2020

      Hi Heather, you can't change the Age calculation but you can create a new for Days Past Due.

      Create a new formula field (that returns a number) on the CTA object and use this formula:
      TODAY() -  JBCXM__DueDate__c

      If we are not past the Due Date yet then the number will be negative.

      Nice workaround...

        Terms & ConditionsAccessibility statement