Age field in Reports
+14I'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)
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.
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.
+14Thanks, 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!
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.
+3Hi 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...
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.