How to change this price column


I have a tag msg as sale,the product under sale are to be priced -10 rs.


Price is 50 it should show 40.only products with tag msg as sale.

  1. Create a math column that subtracts the discount from the price. ([PRICE]-10)
  2. Create and if then else column that results in either a discounted price or the actual price based on the condition of whether or not it’s on sale.
  3. Use the if then else column for display and calculation purposes