Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Northern, NJ, New Jersey, USA
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Formula Formatting (2000 SR-1)

    In a query I have formatted a formula to return the 'OctQ' and the 'OctGA' as follows:

    OctQ: Sum(IIf(Month([month])=10,[GA Quota],0))
    OctGA: Sum(IIf(Month([month])=10,[GA],0))


    In the SAME QUERY - I now need to divide the two. I would think I could divide using the alias i have created but I keep getting errors.

    Why wont this work in the same query:
    OctAttain: ([OctQ]/[OctGA])

    What is the correction? and for the future situations... What is the rule?
    There is always a way.

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Formula Formatting (2000 SR-1)

    Hi,
    Are you getting an error message or simply seeing #Error in the results grid? If the latter, is it possible that you're dividing by zero?
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Northern, NJ, New Jersey, USA
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula Formatting (2000 SR-1)

    I know I should have clarified "error" -sorry <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>

    I am getting a pop up for each of the parameters in the formula OctQ and OctGA
    There is always a way.

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula Formatting (2000 SR-1)

    Did you check the spaces [OctQ] or [Oct Q] and [OctGA] or [Oct GA]
    Francois

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •