Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2007
    Posts
    8

    Unanswered: Formula in query help

    Hi all,

    I have a query that has 3 fields

    ContractorName
    Revenue
    Cost

    After I have run the query I have each contractors total revenue and total cost summed. However I am having triouble generating a gross margin % in the forth field of the query - I've tried this:

    GM %([Total Revenue]-[Total Driver Cost])/([Total Revenue]))

    But it shows up as blank.

    Anyone assist me? thank you in advance.

    Sid

  2. #2
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    Try this:
    GM: ([total revenue].............................................

Posting Permissions

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