Sudden formula errores (it worked before).

Cabelo · 02-24-2022 09:36 AM

Hello there,

I am having some of my prototypes all of a sudden have lots of errors without me having made any changes to them. That is probably the price of progress (happening behind the appsheet scenes).

Anyway, one of my finance trackers are behaving weird. Below is a formula I have that used to work fine. That formula used to gives me the balance for multiple currencies.

Today, as I entered a simulated cash input (see below):

Going to the list where I get the cash balance for each of the currencies, the app had counted the 1000 USD income for all of the currencies instead of only to the US ones as below:

All the formulas still make sense to me, so I am lost to what happened here?

Any lights?

Thank you very much!

Marc_Dillon

Did you mean to write [CurrencyCode] instead of just [Currency] in your expression?

Cabelo

@Marc_Dillon

Thanks a lot! It is solved, you pointed out an important mistake I make, in some places it said 'currency' and in others 'currency code'.

Thanks!