Criteria does not work on a calculated expression

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CDG - 22 May 2008 21:49 GMT

I am working on a query that sums 2 fields separately. I created an
expression to calculate a percentage based on these 2 sums - sum of column 2
/ sum of column 1. I set the format to percentage. The sums and calculation
of the percent work fine. I now need to tell the query to only display
records that have a percentage of 80% or above. When I place >=80 or >=80%
in the criteria area, an error message is displayed. I also tried this in a
filter and did not have much success. Any ideas on how I can get this to
work?

Thank you.

Reply to this Message

KARL DEWEY - 22 May 2008 23:38 GMT

A percentage is a decimal fraction of 1. One hundred percent is one times
the number. Criteria for 80% must be entered as 0.8 as 80 is 800%.

Signature

KARL DEWEY
Build a little - Test a little

> I am working on a query that sums 2 fields separately. I created an
> expression to calculate a percentage based on these 2 sums - sum of column 2
[quoted text clipped - 6 lines]
>
> Thank you.

Reply to this Message

CDG - 23 May 2008 06:09 GMT

I did try the fraction in the criteria and it did not work. This is a
calculated expression field and it seems as if nothing is working to display
the records I need. The 2 columns are sum (aggregates). Any other ideas?

>A percentage is a decimal fraction of 1. One hundred percent is one times
>the number. Criteria for 80% must be entered as 0.8 as 80 is 800%.
[quoted text clipped - 3 lines]
>>
>> Thank you.

Reply to this Message