You need to sign in to do that
Don't have an account?
Durgamba Rayudu
Field may not be used in this type of formula
Hi i used the formula to create Percent Completed of type percent
( TODAY() - DATEVALUE( CreatedDate )) / (CloseDate - DATEVALUE( CreatedDate ))
but getting syntax error Field CreatedDate may not be used in this type of formula. i tried to insert from insert option then giving same error for closed date too. i checked these fields are there in page lay out and in UI
Please suggest me. i am not able to crete this filed itself.
( TODAY() - DATEVALUE( CreatedDate )) / (CloseDate - DATEVALUE( CreatedDate ))
but getting syntax error Field CreatedDate may not be used in this type of formula. i tried to insert from insert option then giving same error for closed date too. i checked these fields are there in page lay out and in UI
Please suggest me. i am not able to crete this filed itself.
The first choice to do while creating the new field is "Formula" then after "Percent".
All Answers
The syntax is correct and works for a Formula field of type Percent.
Where did you create the formula?
The first choice to do while creating the new field is "Formula" then after "Percent".