check two things before counting the number of customer ID's

[#1]

=Count({$<[RMDEL]={'D'}, [CustomerID]={'W*'}>}[CustomerID])

I would like to check if the DELETE field if equal to 'D' and the Customer ID - starts with the letter 'W' then count.

is this correct? I don't seem to be getting any counts.

[#2]

Hi,

The syntax looks right. Are you getting 0 or - returned. If you are getting - then there is something wrong with the syntax.

Thanks

Nick

[#3]

comes back with zero, but checking the data - we have customers who are marked as deleted -

no error messages just no count.

[#4]

Hi,

Do you get a result if you try each condition on it's own?

Thanks

Nick