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

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

Outcomes