Calculating correct percentage - Microsoft Access / VBA

zufie

I have used Sum(Abs([field])) to convert my neg. (-) values to pos.
(+) values how can I obtain the correct percentage.

For example, here is my expression from my query trying to calculate
the correct percentage, in this case, 2/2+3 = .4*100 = 40%.

Expr18: (((Abs(Sum([MinOfAgencyContactYes])))/
(Abs(Sum([MinOfAgencyContactYes])))+
(Abs(Sum([MinOfAgencyContactNo])))))

Expr18 returns 400% instead of 40% due to using Sum(Abs([field])).

How can I correct this?

I am so close to completing this report.

Thanks!,

John

Sep 18 '08 #1

Subscribe Post Reply

2431

zufie

On Sep 18, 3:03*pm, zufie <john.marru...@illinois.govwrote:

I have used Sum(Abs([field])) *to convert my neg. (-) values to pos.
(+) values how can I obtain the correct percentage.

For example, here is my expression from my query trying to calculate
the correct percentage, in this case, 2/2+3 = .4*100 = 40%.

Expr18: (((Abs(Sum([MinOfAgencyContactYes])))/
(Abs(Sum([MinOfAgencyContactYes])))+
(Abs(Sum([MinOfAgencyContactNo])))))

Expr18 returns 400% instead of 40% due to using Sum(Abs([field])).

How can I correct this?

I am so close to completing this report.

Thanks!,

John

I think I figured it out?!

Here is my new expression 18 (I divided by 10 to return the correct
percentage, in this case, 40%).

Expr18: (((Abs(Sum([MinOfAgencyContactYes])))/
(Abs(Sum([MinOfAgencyContactYes])))+
(Abs(Sum([MinOfAgencyContactNo])))))/10

Thanks!!!!!!!!

John

Sep 18 '08 #2

Similar topics

Calculating percentage widths

by: Lars G. Svensson | last post by:

As a regular ciwas reader, I learned that fixed-pixel designs are evil, so for the newly created site http://www.ddc-deutsch.de (in German, still very much under construction) I arranged the...

HTML / CSS

calculating a median within a query

by: jonm4102 | last post by:

I'm trying to calculate the median of some numerical data. The data can only be found in a query (henceforth query 1) field I previously made, and I would prefer to calculate the median in a new...

Microsoft Access / VBA

formula for calculating sales tax (GST)

by: steve | last post by:

Hi All Not sure if this is the right forum, but I need the formula for calculating the amount of Sales tax (GST) from the tax included price In Australia GST is 10% and the standard formula is...

Visual Basic .NET

Calculating score percentages within groups

by: eliana82 | last post by:

I have problems calculating score percentages within groups. I have created a boat program in access where the information provided is name, team, boat and score. The first query I've done is...

Microsoft Access / VBA

Problems in CALCULATING PERCENTAGE in SSRS 2005 Reports..

by: Aswanth | last post by:

I'm Using Asp.Net with C# & Working with SSRS 2005 for Generating Reports.. The Following Expression I'm using in Reports to Show the Percentage of Particular Items in REPORT.. ...

Microsoft SQL Server

Adding New Table Records and calculating a Percentage increase

by: zoeb | last post by:

Hi. I have a form which the user enters 2 years worth of data into (one record per year). The aim, is to populate the table this form is based on with 3 more years worth of data (i.e. creating 3...

Microsoft Access / VBA

calculating

by: lee123 | last post by:

hello it's me again; i am having a problem with calculating some totals in my project. I have fields on my form that need to be calculated to get a percentage in the end I wish i could show you...

Visual Basic 4 / 5 / 6

Calculating correct percentage

by: zufie | last post by:

I have used Sum(Abs()) to convert my neg. (-) values to pos. (+) values how can I obtain the correct percentage. For example, here is my expression from my query trying to calculate the correct...

Microsoft Access / VBA

generated cell in a table using javascript function is not calculating the values

by: sureshl | last post by:

function cal() { var f = document.form1; var regExp_Count = new RegExp("^+$"); f.price1.value = parseFloat(f.baseprice.value*(f.percen.value/100)).toFixed(0); } cal() functions , will...

Javascript

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

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

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

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

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

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

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++

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

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp