IIF FUNCTION and multiple values

[Guest]

Can these formulas be used to count multiple values? For instance, if I want
to count the number of values >8 in addition to the number of values =1. I'm
using it with a text field so please consider this when replying.
Thanks.

=Count(IIf(hours > 8, 1, Null))

=Sum(IIf(hours > 8, 1, 0))

=Abs(Sum(hours > 8))

 

[Stefan Hoffmann]

hi Karina,

Can these formulas be used to count multiple values? For instance, if I want
to count the number of values >8 in addition to the number of values =1. I'm
using it with a text field so please consider this when replying.
=Count(IIf(hours > 8, 1, Null))
=Sum(IIf(hours > 8, 1, 0))
=Abs(Sum(hours > 8))

Do they throw any error?


mfG
--> stefan <--

 

[Duane Hookom]

If I understand correctly, try:
=Abs(Sum(hours > 8 OR hours=1))
If that doesn't meet your needs, please come back with a more complete spec.