How to calculate percentage in my total query?

[awu]

Hi, All:
I posted several message for the same question. I was confused myself
about question. Now I want to change my query to total query. I still
need to calculate the percentage.

I have product line number and device number. Under each product line
and each device number, there are several components. Each component
has its one of 4 status. I use continuous form to display each device
total components and its percentage, e.g.

product1 device1 #ofcomponent %ofstatus1 #OfStatus2

My total query is group by product and device, CountOfComponent. I
could not get percentage of status1 per all components.

I want to use something like, expr1: count(IIF([Status] = 1, 1, 0)) to
get number of status1 based on total number of components. It doesn't
work.

really need help
thank you much
awu

 

[Randy Harris]

I think you're going to need to explain more clearly what output you want.

product1 device1 #ofcomponent %ofstatus1 #OfStatus2

This doesn't make much sense. %ofstatus1, #OfStatus2? Maybe if you
provided an example of what the output should look like.

Hi, All:
I posted several message for the same question. I was confused myself
about question. Now I want to change my query to total query. I still
need to calculate the percentage.

I have product line number and device number. Under each product line
and each device number, there are several components. Each component
has its one of 4 status. I use continuous form to display each device
total components and its percentage, e.g.

product1 device1 #ofcomponent %ofstatus1 #OfStatus2

My total query is group by product and device, CountOfComponent. I
could not get percentage of status1 per all components.

I want to use something like, expr1: count(IIF([Status] = 1, 1, 0)) to
get number of status1 based on total number of components. It doesn't
work.

really need help
thank you much
awu