+1
I have a custom field that captures the Total Authorised committed (Sum of Actuals YTD + ERP Commitments) currency field and Low Estimated Budget (sum of 2025 & 2026 budget & 2027 budget) currency field.
I want to calculate the % of (Total Authorised committed $ / Low Estimated Budget) *100
Error: Loop found in field 'C_TotalAuthorisedCommitted'
Hi
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.
Hi
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.
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.