473,396 Members | 1,743 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

home > topics > microsoft access / vba > questions > how to get the percentage of the difference of 2 totals?

Join Bytes to post your question to a community of 473,396 software developers and data experts.

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

anoble1
245 128KB
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.
Expand|Select|Wrap|Line Numbers
  1. 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?
Sep 25 '14 #1

✓ answered by Rabbit

Divide it by 10
Expand|Select|Wrap|Line Numbers
  1. BONUS10Percent: Sum(Nz([BD_PRC])-Nz([BD_NET])) / 10 

2 981
Rabbit
12,516 Expert Mod 8TB
Divide it by 10
Expand|Select|Wrap|Line Numbers
  1. BONUS10Percent: Sum(Nz([BD_PRC])-Nz([BD_NET])) / 10 
Sep 25 '14 #2
anoble1
245 128KB
Good grief! That easy..... Thanks
Sep 25 '14 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

0
percentage difference between ie and mozilla
by: null Effects | last post by:
I made a page that has some divs that I would like to line up next to each other. I used percentage values to set their positions and sizes, but in IE6 there are breaks in between them and I can't...
HTML / CSS
4
counting the percentage and occurence of each identical word in input file
by: fhmm | last post by:
I am an intermediate programmer and i tried to solve the following programme but with no success the programme is a simple text analyzer that read an input file and cumpute the occurence and...
C / C++
12
Showing Percentage in a Query
by: aldeb | last post by:
Below is the code I am using in a query that produces results that look like: Fault Category-------------No Fault Totals No Faults------------------------------77 Total Work...
Microsoft Access / VBA
4
Report "Percentage claculation of Totals and Grand Totals"
by: Micheal | last post by:
Greetings Access Group, Being relatively new to Access, I try to work through problems on my own and have been very successful, although I have a conundrum that I have been working on for two days...
Microsoft Access / VBA
38
Trouble calculating percentage in C++ dice program
by: d0ugg | last post by:
I'm writing a program that will have to roll the dice A and dice B one million times, and calculate the percentage of times that the dies will be equal. I'm having trouble to figure out how the...
C / C++
8
Nathan H
Find Percentage difference among fields in a record
by: Nathan H | last post by:
I am trying to write a query that will result in showing records that have a large percentage difference among fields in a table. For instance: Table field1.Item field2.account1 (percentage)...
Microsoft Access / VBA
7
percentage
by: Bill Cunningham | last post by:
I need help on this utillity it is supposed to take as its first argument a number and its second argument a subtraction of that number say for example 20 and 2. The program should calculate the...
C / C++
0
Comparing Difference (in Years) Between Two Dates & Totalling -Troubleshooting
by: sharsy | last post by:
Hi, I've setup a query that compares the difference (in years) between two date fields (Joining Date & Date Cancelled) and then totals how many people fit into each category (0 years, 1 year, 2...
Microsoft Access / VBA
5
Percentage of negative values out to the total number of fields
by: JessSmith | last post by:
Hi I have a query which has fields in showing how close a client is to their renewal date, or how overdue they are. I wanted to have a totals column at the bottom of the query showing what...
Microsoft Access / VBA
0
How to turn on java script in a villaon keypad mobile phone
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
Java
0
Merging data from multiple Excel files
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
Data Management
1
Looking to do Android software development, any suggestions? Is flutter better?
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
General
0
How to build RAID in BIOS?
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
Computer Hardware
0
marktang
What is ONU?
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
General
0
Changing the language in Windows 10
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
Windows Server
0
Oralloy
Problem With Comparison Operator <=> in G++
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
C / C++
0
jinu1996
Maximizing Business Potential: The Nexus of Website Design and Digital Marketing
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
Online Marketing
0
The easy way to turn off automatic updates for Windows 10/11
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
Windows Server

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap
Advertise on Bytes:
Post a Job
Sponsored Posts
Platinum & Gold Sponsors
Hire Now!