Custom Field to calculate what % of Financials Fields 

Hi ​@tumisomahlake 

You are referencing the field itself in the formula, which is why you are seeing the loop error:

The API name for a field must be unique on the object - does your original “Total Authorised Committed” field have the same API name perhaps? Update the API name on the % field, and then it should work.

Thank you. The formula is working.

Good day ​@petegush 

How do I change the Percentage? Error to 0 when there  are no values entered.

Hi ​@tumisomahlake

You can wrap the formula in the CATCH function, which will return a default value if the formula results in an error.

For eg, to return a blank value instead of an error when dividing by zero try

Catch($FieldA/$FieldB, NULL)

where $FieldA/$FieldB is your formula.