#IERR error in simple calculation

[xlbo]

This has me stumped

I have brought back a list of outlet numbers, customer numbers and agreement numbers by week for the last 4 weeks. I have then created 3 variables:
Houses = count(<Outlet Number>)
Customers = count(<Customer Number>)
Agreements = count(<Agreement Number>)

I have then created a comparison variable for houses, using the Previous function: =Previous(<Houses>)
All is well and good with this.

I have then done the same for Customers & Agreements but I get a #IERR error when trying to display them in the report BUT, the =previous(<Houses>) variable works fine...

Any ideas ???

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question