Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Calculate an amount from 2 fields

Quote Reply
Calculate an amount from 2 fields
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
Subject Author Views Date
Thread Calculate an amount from 2 fields rcaudio 5107 Dec 22, 2002, 10:23 PM
Thread Re: [rcaudio] Calculate an amount from 2 fields
jaspercram 4951 Dec 22, 2002, 11:59 PM
Thread Re: [jaspercram] Calculate an amount from 2 fields
rcaudio 4941 Dec 23, 2002, 10:51 PM
Thread Re: [rcaudio] Calculate an amount from 2 fields
jaspercram 4932 Dec 24, 2002, 1:16 AM
Post Re: [jaspercram] Calculate an amount from 2 fields
rcaudio 4918 Dec 24, 2002, 11:04 PM