Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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's avatar
    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
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi RuanG,

 

You can use switch statement to check the condition of this statement.

 

Like,

 

CC_Status = SWITCH(TRUE(), PBI_Data[CC] <= 30, "WEAK", AND(PBI_Data[CC] > 30, PBI_Data[CC] <50), "MODERATE", AND(PBI_Data[CC] > 50, PBI_Data[CC] < 99), "STRONG", PBI_Data[CC] = 1, "PERFECT", "NO")
 
This would helps you a lot.
 
Regards,
Pradeep