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 $75k, or Equal/Less $75k.   

 

In other words, imagine you have the orders table, and you quickly want to filter down to all Orders with a total value over 75,000 dollars...or....select all orders with a value below 75,000.    

 

And the key is that this should be at the Order level  (not at the line level).   

 

Thanks for any help!

 

 

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.
     

3 Replies

  • jppv20's avatar
    jppv20
    Solution Sage
    4 years ago

    Hi Anonymous ,

     

    Can you provide some example data and expected output?

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    jppv20    Sure!     

     

    Order Number   Order Value  OVER 75K

     

    A-124                   78,909           TRUE

    A-326                   67,098           FALSE

    C-568                   75,004           TRUE

    • jppv20's avatar
      jppv20
      Solution Sage
      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.