Bug in App expression

Aparicio_Pineyr · 07-19-2021 08:25 AM

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.

Steve

Two thing you could try:

Don’t quote TRUE and FALSE.
```
[PVID9]=TRUE
```
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])
```

Aparicio_Pineyr

Solve it thanks