Bug in App expression

Hi!
I had 3 tables where they have several columns with this kind of expression:
The โ€œTRUEโ€ value gets the [Y/N], where I change the subject values to Spanish (No/Si), and โ€œtable data localโ€ is set in Spanish.
TRUE/FALSE values in the spreadsheet are automatically translated in Spanish, in all 3 spreadsheet tables when the value is add by the App.

IF(
[PDV9]=โ€œTRUEโ€,5
,0
)

The weird thing is that the expressions are working fine in one table, but they are not working at all in other two tables.
All expressions are simple as the example above, some of them are decimal or number type column, in the spreadsheet columns are set as automatic with 1 decimal digit.

0 2 130
2 REPLIES 2

Steve
Platinum 4
Platinum 4

Two thing you could try:

  1. Donโ€™t quote TRUE and FALSE.

    [PVID9]=TRUE
    
  2. Donโ€™t compare a Yes/No value to TRUE to determine if itโ€™s trueโ€“itโ€™s entirely redundant. This is sufficient to check whether itโ€™s TRUE:

    [PVID9]
    

    To check whether itโ€™s FALSE:

    NOT([PVID9])

Solve it thanks

Top Labels in this Space