Data not transferred to appsheet

[li_Hua]

Hi, will appreciate help on this, there is a google sheet formula in the source

Here is how the app looks like

But the Replenishment(MOQ Qty) is still not appearing when there is data in the source? I have made the app read-only and the data field for the column I am asking about,number so are the ones that are included in the formula. Just to clarify, there is also no error warnings given and I have regenerated the source multiple times yet it is still showing the same error.
Does anyone know the reason?

[Steve · Accepted solution]

Try computing the value in the app with an expression rather than with a formula in the spreadsheet.

[li_Hua]

Thank you! It worked!