Expresion decimals

[Auxiliar_Labora]

Hello!

im having trouble with the next expression:

LIST(
IF(
OR( [PH]<1.5 , [PH]>9 ),
(15) , (0) )
3, 4)

15 on Bold, its really 1,5 (decimal) but i cant use “,” or “.” because it gives me error. (
LIST has elements of mismatched types)

The result should be:
(1.5 , 3, 4) or
(0, 3,4)

15 on Bold, its really 1,5 (decimal) but i cant use “,” or “.” because it gives me error.

[Steve]

help.appsheet.com

List from Values

Create a list from raw values.

[Auxiliar_Labora]

Thank you very much Steve for your attention. I had already read that document, but it still does not resolve my concern.

[Steve]

help.appsheet.com

Column Types: Diving Deeper

Learn more about each column type you can have when structuring your columns.

[Auxiliar_Labora]

There is the column “PH” which is of type DECIMAL.

There is other column “SUM. RIESGOS” which is of type ENUM with Base Type “DECIMAL”
.

Finally, with actions, calculates the content for the “SUM. RISKS” COLUMN.

The problem is that the list I am trying to build for the field [SUM. RISKS] does not accept the value of “1.5” (decimal) as one of the elements, despite the fact that it is DECIMAL as Base Type

[Steve]

0 is a Number, 0.0 is a Decimal.

[Auxiliar_Labora]

Hi Steve, i know that, but my problem its not 0 (in fact it is included in the list without any problem as is as), my problem is “1.5”

[Auxiliar_Labora]

Hello, I change the question. is it not possible to create a list of decimal values?

LIST (1.5 , 3, 4) ------> ERROR
LIST (1,5 , 3 , 4) ----> (1 , 5 , 3, 4)

[Rafael_ANEIC-PY · Accepted solution]

Auxiliar_Laboratory:

LIST (1.5 , 3, 4) ------> ERROR

1.5 is a decimal value, but 3 and 4 are not, try (1.5,3.0,4.0)

[Auxiliar_Labora]

Solved.

I was confused by a misinterpretation of this:

I entered all values as decimal and problem solved.

THANK YOU VERY MUCH!!