IF Statement not working with Commas (Decimals)

Good day, I am encountering an issue that I believe has something to do with my Locale settings. Nonetheless I have not yet figured out the reason why this is not working. I am doing a calculat...

Need Help

Nishantjain

7 years ago

Anonymous

You need to replace the "||" with "&&". "||" is an alternate for "Or".

In your formula , if the value is more than 0,30 or less than 0,50, that will give "Moderate" and 0,72 is more than 0,30.

I would suggest you change your formula as below

Option 1:

IF (
    CC <= { 0, 30 },
    "Weak",
    IF (
        CC > { 0, 30 }
            && CC <= { 0, 50 },
        "Moderate",
        IF (
            CC > { 0, 50 }
                && CC <= { 0, 99 },
            "Strong",
            IF ( CC = { 1 }, "Perfect", "No" )
        )
    )
)

Option 2:

Switch is a better way to write nested "Ifs". See if this makes sense

SWITCH (
    TRUE (),
    CC = 1, "Perfect",
    CC > 0,50, "Strong",
    CC > 0,30, "Moderate",
    CC <= 0,30, "Weak",
    "No"
)

Thanks

Forum Discussion

IF Statement not working with Commas (Decimals)

Related content

Decimal level parameter not working

Decimal Precision

OR Statement ?

subtotal not work in metrics (value has "if" statement)

Switch Statement Not Working