function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
ArmanMArmanM 

Custom Field help

Hi, 

We are trying to create a custom percentage formula field but we are getting an Syntax error.  This field checks to see if the calculated percent is less than 100%, if it is greater than 100% the value should be left at only 100% but otherwise leave it at the given formula. So far we have this;
IF((Total_Booked__c / Product__c) > 1 ,​​ 1 ,(Total_Booked__c / Product__c)) 

Please hlep us figure out the error.

Thank You !
Mammu4Mammu4
I have the same formula working for two number type fields.
what are the field types of Total_Booked__c and Product__c?? Can you paste your error?
ArmanMArmanM
Total_Booked__c : Number
Product__c: Number
Error: 'Syntex Error' 
Mammu4Mammu4
I don't see anything wrong with the logic. In the error did it say anything like this: syntax error:missing attribute?