I have a form which calculates discount based on certain criteria. the form is as below
While adding a new record the discount gets calculated without any issues. But when the saved record is opened for editing, the column initially brings up the value for a few seconds and then turns blank as shown below.
The formula used for fetching the discount is
The PriceListMultiplier List is as below with index on ColumnForLookup.
Please could you advise on why this unexpected behavior is happening and a possible solution.