IF and AND in the same expression

[#1]

Hi Community,

I need to count NULL registers, when 2 conditions are required at the same time. I've try with

=COUNT(IF([Fecha de devolución a cedente]='' AND [Fecha de recepción]= '') id_counter1) but no luck. I'd appreciate if you could bring some light in my darkness!

Thanks in advance for your help!

Regards,

Vincent

[#2]

Try:

COUNT( IF ([Fecha de devolución a cedente]='' AND [Fecha de recepción]= '', id_counter1) )

[#3]

Hi Ajay,

It hasn't worked, but I've finally managed to do it.

FYI:

= COUNT( IF (IsNull([Fecha de devolución a cedente]) AND IsNull([Fecha de recepción]) , id_counter1 ) )

Regards,

Vincent

[jagan]

Hi Vincent,

You can try this in set analysis

= COUNT({<[Fecha de devolución a cedente]-= {'*'}, [Fecha de recepción]-={'*'}>} id_counter1 )

Regards,

Jagan.