Thank you Nicky. Here are the formulas that do the trick provided gratefuly by William Stacey -----------------------------------------------------------------------
if you only know the adjusted (disounted) price and the discount then my formula a=(p-(dp/100)) can be solved for the original price p as: p=(a/(1-d/100)) ------------------------------------------------------------------------ The problem I had was that I needed to get the original price ( discount = 0%) when I only have the adjusted (discounted) price and the the discount value based on the original price that is not available. The above formulas work great. Thank all for your cooperation, Manuel de Aguiar Nicky Avery wrote: > > 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/
