Using extended sql - IN operator bringing #IERR

I have a  very simple report with thee objects in the data provider
Dimensions - Agent Number, Quote Type
Measure - Count of Quote Enquiries

I am trying to create a report that has Agent Number, Count of Quote Enquiries, and a variable created by me Count of Annual.

The count of annual object is causing me the grief - I dont want the Quote Type object in the report so am using 'IN' to give an output context
The variable looks like this -
=Sum(If <Quote Type Desc>="Annual" Then  Sum(<Count of Enquiries>)) In  (<Quote Type Desc>)

this gives me the #ierr - I have tried using forall/foreach too but no success!

I have been able to use a similar approach on a completely different report as below - although i appreciate without the background it may be of lttle use for me to post!
=Sum((If <IBCL Booking Date>><Due Next Month Full End OF Month> Then<Sum Actual Layer Amount(SCG)> Else 0) In ( <IBCL Booking Date> ,<SL Due Date>))