AnsweredAssumed Answered

Calculated field with lookup does not update on edit

Question asked by allath on Jun 9, 2017
Latest reply on Jun 12, 2017 by emha



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.