Forum Discussion

MintuBaruah's avatar
MintuBaruah
Helper III
5 years ago
Solved

Percent in condition

Hello @all 
 
I wanted to compare the values from a measure and use the following condition: 
Formula: Calculated Col = IF([Measure] > 20% , "Yes", "No")
but this is giving me an error.
The measure in the above formula calculates values and then in "formatting", I have it displayed in percent.
Can I not use the percent sign to compare and use in the above formula. If so please provide a solution on how to resolve this.
 
Thank you
Need Help
  • FarhanAhmed's avatar
    FarhanAhmed
    5 years ago

    Try below

     

    Calculated Col = IF([Measure] > 0.20 , "Yes", "No")

     

    If you using Formatting of measure then it is only for displays unless you are using "FORMAT" in the measure itself.

     

     

1 Reply

  • FarhanAhmed's avatar
    FarhanAhmed
    Community Champion
    5 years ago

    Try below

     

    Calculated Col = IF([Measure] > 0.20 , "Yes", "No")

     

    If you using Formatting of measure then it is only for displays unless you are using "FORMAT" in the measure itself.