Hello!
im having trouble with the next expression:
LIST(
IF(
OR( [PH]<1.5 , [PH]>9 ),
(15) , (0) )
3, 4)
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.
Thank you very much Steve for your attention. I had already read that document, but it still does not resolve my concern.
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
0 is a Number, 0.0 is a Decimal.
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”
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)
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)
