Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try:
COUNT( IF ([Fecha de devolución a cedente]='' AND [Fecha de recepción]= '', id_counter1) )
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
Hi Vincent,
You can try this in set analysis
= COUNT({<[Fecha de devolución a cedente]-= {'*'}, [Fecha de recepción]-={'*'}>} id_counter1 )
Regards,
Jagan.