Problem in calculation

[tRIXY]

Hi guys,

I have a qry that displays info (see attached) which i then i export to a spreadsheet in excel.I need to add a column within my query to display the total results. Ths formula i have been using is Total_Units: iff([SoldCount]=[NoCount],[NoCount]*-1,[SoldCount]-[FreeCount]-[EmployeeCount]-[ManagerCount]

As you can see from the attached the first part of this formula works fine displaying the result as a - figure but it is not calculating [SoldCount]-[FreeCount]-[EmployeeCount]-[ManagerCount] if sold count is not equal to no count.

Hope this makes sense ! any ideas

Thanks

 

[Brianwarnock]

Your test data is not a lot of use since most of the fields are zero, ie all of FreeCount EmployeeCount ManagerCount and on that basis it looks like it is working, posting the database would have been more use if there had been an error.

Brian