Arithmatic Expression

[Wanahmad]

This is what comes out when I try to use [Bilangan Tanggungan]>0
Arithmetic expression ‘([Bilangan Tanggungan] > 0)’ does not have valid input types

[Elijah_Magrane]

Are both you spreadsheet and appsheet column type formatted to number?

[JTWhite6789]

I have run into a similar issue and was wondering if you ever found the solution? I am getting the same error. My app and spreadsheet are both formatted to numbers.

I have tried the IF expression and also the IFS and AppSheet doesn’t like “>” input, but it will take “=” or “<>”.

[Aurelien]

Hi @JTWhite6789

make sure numbers type are equals.
Keep in mind that Number is different from Decimal.
If you wish to compare with a decimal, remember to add a dot to explicit that.
For example:
IF([thisDecimal]>0.0, ResultIfTrue, ResultIfFalse)

[JTWhite6789]

Thank you for the quick response. I did verify column types in both the spreadsheet and app to confirm they matched. I also removed some " " around the >=number and now it seems to be working.

My final expression (for future reference) is

IF([ColumnA] >= 500000, “Yes”, “No”)

[Aurelien]

@JTWhite6789

Glad you made it.

For your information, this:
IF([ColumnA] >= 500000, “Yes”, “No”)
can also be written, if it’s in a Yes/No column, simply:
[ColumnA] >= 500000
No need to use an IF statement for simple cases

[JTWhite6789]

Thanks.