I have a table called ExpenseFact which has one Lookup Type column called "AccountType", one custom column called "cGST" that removes 15% of an existing field called "Total", and another custom column that is derived from "cGST" field and is called "cTotalLessGST" which is simply "Total" - "cGST" field.

When I created the two custom formulas the values were refreshed correctly with no issues.

However, if I update the value in the Lookup Type column called "AccountType", the following errors occur:

1.  the "cGST" field has the value "Needs Save"

2. the "cTotalLessGST" field says "NaN"

See attached screenshot.

The question is why does a change in the "AccountType" field influence the custom formulae?

Secondly, I am unable to save the change as it says invalid data found in "cTotalLessGST".

Is this a known issue? Is there a work around?

Thanks

Sunil