Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

If statement custom column

Hi guys,

 

I'm trying to create a new column where the output value is dependent on the numerical value in a different column. This is create a slicer that allow the user to choose between grouped ranges of values.

 

The query is as follows:

 

if [Score] <= 0.2499 then "Info"
else if [Score] >= 0.25 if [score]
else if [Score] >= 0.50 & [Score] <= 0.7499 then "Medium"
else if [Score] >= 0.75 & [Score] <= 0.899 then "High" else "Critical"

 

When this custom column is computed, the first line works (there are rows returning the 'info' value), however the output for the rest of the rows is an error.

 

an example of the error statement:

 

Expression.Error: We cannot apply operator & to types Number and Number.
Details:
Operator=&
Left=0.25
Right=0.454

  • Anonymous's avatar
    Anonymous
    5 years ago

    Nevermind, I fixed it; just got to replace '&' with 'and'

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Nevermind, I fixed it; just got to replace '&' with 'and'

  • Anonymous's avatar
    Anonymous
    Not applicable

    Anonymous 

    Good, remember AND operator is (&&) not just (&), and OR operator is (||).

     

    Paul Zheng _ Community Support Team