Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Calculated Column - True False based on Order value

Hello Community  -  I know this should be easy, but...   I have an orders table out of our ERP system.   I need to create a "flag" that allows the user to have a slicer with the two options:  Over ...
Need Help
  • jppv20's avatar
    jppv20
    4 years ago

    Anonymous 

     

    This formula should work:

    OVER 75K = IF('Table'[Order Value]>75000,"True","False")
     
    Or you can use this formula:
    OVER 75K = 'Table'[Order Value]>75000
     
    If I answered your question, please mark it as a solution to help other members find it more quickly.
     
jppv20's avatar
jppv20
Solution Sage
4 years ago

Hi Anonymous ,

 

Can you provide some example data and expected output?