Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Need a semi complex if / Else statement

I'm trying to create a new column that looks at an existing column called % Completed (if contains numerical values from 0 to 1 and blanks) and then outputs text based off what value is in that colum...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous,

 

Table means your table name who host the column.(where [% Completed] field exists)

 

Regards,
Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Column =
IF (
    AND ( [% Completed] > 0, [% Completed] < .661 ),
    "Learning Started",
    IF (
        AND ( [% Completed] > .66, [% Completed] < 1 ),
        "Knowledge Stage Completed",
        SWITCH (
            VALUE ( Table[% Completed] ),
            1, "100% Completed",
            0, "Not Started",
            "", "Account Created, Not Started"
        )
    )
)

I'm now seeing a Function 'SWITCH' does not support comparing values of type Number with values of type Text error. Consider using the VALUE or FORMAT function to convert one of the values.  I tried formatting the column (which was set to Decimal Number and General) to Decimal Number and Decimal Number - didn't help.