Results 1 to 5 of 5
  1. #1
    funky2016 is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Jul 2016
    Posts
    3

    How to create a formula to get the total sales percentage

    Hi,



    I'm working on a database and would like to get a formula when the status change to sold and will appear the sales percentage? Can you help me?

  2. #2
    funky2016 is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Jul 2016
    Posts
    3
    Click image for larger version. 

Name:	database.JPG 
Views:	14 
Size:	115.1 KB 
ID:	25166 I would like to get the percentage when I filter the status to Sold. Is there a formula that I can use?

  3. #3
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Is that a Form or a report? How are you totaling the column?

  4. #4
    funky2016 is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Jul 2016
    Posts
    3
    This is a report. I added a box to calculate the total amount. Do I need to create a query form to show our closing sales ratio? How should I do that?

  5. #5
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    A Report has some unique properties. It makes several passes to completely define the report *before* printing. As such you can place a control in the Report Footer (visible or not) that sums the column you want. You can then reference that control in each line of the report detail and create the percentage of the total value you are looking for.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Percentage of Total
    By uaguy3005 in forum Queries
    Replies: 3
    Last Post: 12-22-2015, 01:32 PM
  2. Percentage of Total
    By O.92 in forum Queries
    Replies: 4
    Last Post: 12-03-2015, 01:19 AM
  3. total sales showing on a form
    By Jen0dorf in forum Access
    Replies: 3
    Last Post: 12-01-2015, 04:20 PM
  4. How to get Total Sum to percentage%
    By Kitz14 in forum Queries
    Replies: 1
    Last Post: 07-15-2015, 11:02 PM
  5. computing total sales per day using query
    By joms222 in forum Queries
    Replies: 0
    Last Post: 03-09-2009, 10:58 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums