How to get the percentage of the difference of 2 totals?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • anoble1
    New Member
    • Jul 2008
    • 246

    How to get the percentage of the difference of 2 totals?

    I have a query that I am trying to get a field to calculate a percentage based off 2 totals.

    Here is my current query field that I am editing.
    Code:
    BONUS: Sum(Nz([BD_PRC])-Nz([BD_NET]))
    I wish I could take that what spits out and get 10% of that total. So, if I ran that query and that field gave 1527.2 I would like the formula to calculate 10% which would be 152.72 I have tried a few things, but didn't work. Ideas?
  • Rabbit
    Recognized Expert MVP
    • Jan 2007
    • 12517

    #2
    Divide it by 10
    Code:
    BONUS10Percent: Sum(Nz([BD_PRC])-Nz([BD_NET])) / 10

    Comment

    • anoble1
      New Member
      • Jul 2008
      • 246

      #3
      Good grief! That easy..... Thanks

      Comment

      Working...