Hi,
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
lookup("PriceListMultiplier","ColumnForLookup",FmlHiddenCoulmnForItem,"Multi")
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.
Thanks