Forum Discussion

Oros's avatar
Oros
Post Prodigy
4 years ago
Solved

True/False, if statement

Hello,

 

I need to add a column (FINAL PRICE) that is based on another column (TRUE/FALSE).  If the product discounted=FALSE, then multiply REGULAR PRICE by one (1), otherwise put DISCOUNTED PRICE. Thanks.

 

 

Need Help
  • dhruvinushah's avatar
    dhruvinushah
    4 years ago

    Hi Oros , 
    Assuming your table's datatype for the Discounted Column is formatted like this: 


    Try this to create your FINAL_PRICE column:

    Final Price = IF( 'True False'[Discounted]=TRUE(), 'True False'[Discounted Price], 'True False'[Regular])

     

    Hope this helps, tag me (@) if you need more help on it. Feel free to mark the answer as a solution if it helped you.
    Thanks!

3 Replies

  • dhruvinushah's avatar
    dhruvinushah
    Responsive Resident
    4 years ago

    Hi Oros , 
    Assuming your table's datatype for the Discounted Column is formatted like this: 


    Try this to create your FINAL_PRICE column:

    Final Price = IF( 'True False'[Discounted]=TRUE(), 'True False'[Discounted Price], 'True False'[Regular])

     

    Hope this helps, tag me (@) if you need more help on it. Feel free to mark the answer as a solution if it helped you.
    Thanks!