Problem with IFS() use

[Marco1212]

Hi !
I want to use a multiple conditionnal function for my column [Sigma] with IFS().

[Sigma]'s column type is a decimal and not a date…So I don’t understand why it send me this message.

Thank you for your help on this topic.

[Suvrutt_Gurjar]

Please try removing double quotes around the resulting decimal values in the expression. In general. double quotes need to be used for text values. You could possibly try removing quotes around % values as well if those are percentage columns.

Please see the article below. @steve has nicely explained the issues with double quotes for decimal with examples.

help.appsheet.com

DECIMAL()

Decimal from any value

[Aurelien]

Nice @Suvrutt_Gurjar

In addition, decimals are with dots in AppSheet.
Commas are of local use in France

[Suvrutt_Gurjar]

Yes true @Aurelien

[Marco1212]

Thank you all, it works now !