+ Start a Discussion
Durgamba RayuduDurgamba 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.
Best Answer chosen by Durgamba Rayudu
Alain CabonAlain Cabon
It is not a field of type percent with a formula but a formula field of type percent.
The first choice to do while creating the new field is "Formula" then after "Percent".

All Answers

Alain CabonAlain Cabon
@Durgamba Rayudu

The syntax is correct and works for a Formula field of type Percent.

Where did you create the formula?
Durgamba RayuduDurgamba Rayudu
under opportunity -- Fields& relations ship -- new field of type percent and enter this formula in formula editor. because of check syntax error not able to add this field. even other formula field also giving same error. 
 
Alain CabonAlain Cabon
It is not a field of type percent with a formula but a formula field of type percent.
The first choice to do while creating the new field is "Formula" then after "Percent".
This was selected as the best answer
Durgamba RayuduDurgamba Rayudu
thank u so much. got confused. it worked.