Math Expression Result Not Showing on Excel

[Cabelo]

Hello team,

I’m working on an expenses tracker app for multiple currencies and I got to the expressions now.
I am currently dealing with a math expression whose result I would like to appear/sync on the app’s excel sheet as well.
It is not a virtual column, just a “([Amount Received] / [Amount Given])” formula on the auto compute field and it is working well on the app, but the results don’t appear on the excel sheet. Is there a solution for this?

Thank you very much!

[Aleksi]

So… the calculated cell/column is totally blank in your Excel?

[Cabelo]

@Aleksi
Yes!!!

[Aleksi]

Have you checked that spreadsheet is the same? Are there other columns in the same sheet that are updating correctly?

[Cabelo]

@Aleksi

It is working indeed, but as I should have suspected, those results will only be updated for new entries. For some reason I hadn’t tried a new entry yet, and the new entries work like a charm, it is just the old ones that don’t!

Thank you very much!

[Aleksi]

The reason is simple… the app formula is evaluated only when the record is opened. If you try to update it, you need to open the record. With the new entry that will happen because the record is opened and saved.

[Cabelo]

Thanks! @Aleksi

That is very clear now, it makes a lot of sense.

[Aleksi]

You’re welcome