Hello!
im having trouble with the next expression:
LIST(
IF(
OR( [PH]<1.5 , [PH]>9 ),
(15) , (0) )
3, 4)
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.
Solved! Go to Solution.
1.5 is a decimal value, but 3 and 4 are not, try (1.5,3.0,4.0)
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)
1.5 is a decimal value, but 3 and 4 are not, try (1.5,3.0,4.0)
Solved.
I was confused by a misinterpretation of this:
I entered all values as decimal and problem solved.
THANK YOU VERY MUCH!!
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |