3 Replies Latest reply on Nov 6, 2012 12:29 AM by pinocchio

    Help with percentage calculation

    pinocchio

      Title

      Help with percentage calculation

      Post

           Hi !

           I have built a database that contains information on selected print media (magazines), prices on specific formats and a field that holds the discount rate. The discount has been entered as e.g. "15" for 15%.

           My problem is, that I cannot seem to get a proper calculation that gives me the price after rebate has been subtracted. I realize, that all I have to do is to multiply the base price by 0,85 - but how do I convert the "15" to 0,85 ? I have tried this in the calculation field, but it does not generate the proper value:

           (AdType1 * Price1) + (AdType2 * Price2) * (100 - Rebate) / 100

           Hope someone can help!