I'm trying to make a calculations from 2 fields in the same table.
I have a field named "MSRP" for the Retail Price of the item, and a field named "Price" for my sales price.
I want to subtract the "Price" from the "MSRP" in my template and display the difference as "You Save" to my site customers. I would also like to display the percentage that is saved.
See an example of what I mean at: http://www.overstock.com
Any help would be greatly appreciated!
Thanks,
Rick
I have a field named "MSRP" for the Retail Price of the item, and a field named "Price" for my sales price.
I want to subtract the "Price" from the "MSRP" in my template and display the difference as "You Save" to my site customers. I would also like to display the percentage that is saved.
See an example of what I mean at: http://www.overstock.com
Any help would be greatly appreciated!
Thanks,
Rick