JSL script - After update table, run the embedded formula

[#1]

Hi,

I am trying to update my existing table on column name "Capacity". As you can see in the picture below, once the Capacity column is updated, "Predicted_Shipment_1" column need to change the value according to the fomula embedded inside. However, once I run the script below, the value in "Predicted_Shipment_1" column does not change according to the updated Capacity column. Is there anything wrong with my script below?

dt2 << Update(
With( dt3 ),
Match Columns( :Time = :Time ),
Add Columns from Update table( "Capacity" )
);

column(dt2,"Predicted_Shipment_1") << delete formula;

dt3 << Update(
With( dt2 ),
Match Columns( :Time = :Time ),
Add Columns from Update table( "Predicted_Shipment_1" )
);

At the end the value in column "Predicted_Shipment_1"  updated in dt3 is the old value which is not according to the formula embedded inside. Anything wrong with the formula above?

[#2]

@ReginaHong,
          When you delete the formula and re-create the column, there is no formula in the column to run that will update the values of the Predicted column. The values that are generated due to your update/join operation will be held in the column. 

[#3 · Accepted solution]

Thank you for your replied. I have found solution for this. Just add in the syntax below and it will help to run the formula.

column(dt4,4) << Eval Formula(1);