Manuel,
A computed col "costprice" with the formula (listprice*(1-discount)) will deal with 0 as well as > 0 discount values. You have to express the discount field value as the actual discount (0.nnn) not the residual price, of course. For markup, it's the same idea either saleprice=(costprice*(1+markup)) or (costprice*markup), if you express the markup as 1.nnn. Nicky ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
