Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 02, 2021 12:38 PM
Hello,
I need help creating a formula that calculates the net price of a product based on the discounted % given to the unit Cost.
Example
Unit cost: 300$
Discount: 50%
Net price: 150$
Column Names:
Unit Cost ( original price of product )
Discount (discount % for this product)
Net Unit Cost ( price of the product after the discount is applied)
Any help would be greatly appreciated (:
thank you!!
Sep 03, 2021 04:40 AM
Assuming your columns are literally labelled “Unit cost” and “Discount”, then the formula would be:
{Unit cost}*Discount
You may also want to switch the formatting to Currency too, so that it automatically puts the $ and decimal points in place for you. Like this:
Sep 03, 2021 04:55 AM
I think Alyssa almost has it, but her formula only calculates the discount in absolute terms. {Net Unit Cost} should be…
{Unit Cost} - ({Unit Cost}*{Discount})
Probably don’t need the parens, but I don’t trust evaluation order when I absolutely don’t know what it is.
Sep 03, 2021 06:56 AM
Yes this worked (: Thank you so much!