How to change this price column

Hi

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

Means,

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
3 Likes