You need to sign in to do that
Don't have an account?
ShadowSong14
Syntax Error
Hello,
I am trying to create a new report to determine the Age of a Task from the created date... I tried using this formula
Today() - CreatedDate
However, it tells me " Error: Invalid custom summary formula definition: Field CreatedDate does not exist. Check spelling."
Why is this so? What should I do?
Thanks,
ShadowSong
Hi,
You need to create this new formula field - return type number on the object in setup,
Today()-Datevalue(CreatedDate)
if you are using a custom report type, you need to add this field to the report type as well, and so after that this field would be available in your report, you only need to drag and drop.
in custom summary formulas you can only use numeric fields available in the report.
https://help.salesforce.com/HTViewHelpDoc?id=building_custom_summary_formulas.htm&language=en_US
Hi
You have to do this with formula field, Create formula field , and choose return type as number in object. Then
formula is "NOW()-CreatedDate"
add this field in to your report.
Hi,
Today() is meant for returning the datevalue alone, but created date will be a DateTime value.
So, you need to do is use the formula like this Today() - DATEVALUE(CreatedDate)
Hope so this helps you...!
Please give kudos by clicking on the star icon and mark this answer a Solution, if you found this answer as helpful.
Hi,
Create new formula field - return type number on the standard or custom object,
Today()-Datevalue(CreatedDate)
For more detailed information look at the fallowing link
http://crmsuccess.blogs.com/files2/100_sample_formulas_v6.pdf
and if you have any more questions please feel to contact me on support@groundwireconsulting.com