Your input is appreciated, I'm creating a formula field called consumption is a result of dividing two numeric fields (Modified Usage, and Range) that will return a percentage of usage for example. If the Modified Usage is 80 and the Range is 100 then I want it to show 80%.
`IF( Modified_Usage__c / (Value(TEXT(Range__c))+0)> 1,1, (Modified_Usage__c /(Value(text (Range__c))+0)))`
Definitions: Modified Usage is a numeric field The range is a picklist hence the Value(Text... Consumption is the percentage of consumption based on the formula calculation.
I am not getting any Syntax errors before saving the formula field, but I get an #ERROR! once I add the field to the page layout for any and all entries. Suggestions are welcome. I've looked through the documentation and know I'm not dividing by zero for the error to occur.