SLOW formula

[Guest]

I have posted this question before, but didn't get any replies. Can anyone
help?

=IIf(Count([ph])=0,Null,Sum([outsideph])/Count([ph])*100)

Any ideas on how to replace this formula so that my report doesn't take 3
weeks to open?

Thanks in advance!

 

[John W. Vinson]

I have posted this question before, but didn't get any replies. Can anyone
help?

=IIf(Count([ph])=0,Null,Sum([outsideph])/Count([ph])*100)

Any ideas on how to replace this formula so that my report doesn't take 3
weeks to open?

Thanks in advance!

Without knowing anything about the table upon which this is based, what ph is,
what is indexed and what isn't... not particularly. What's the context? Is
this calculation done on every row of 100000 rows, or in a query, or what?

John W. Vinson [MVP]

 

[Doug M]

One idea would be to put this expression into the query underlying the
report instead of on the report itself? It's not clear how you are getting
outsideph if there is no ph - are both these values coming from the same
table?

Doug