Hi,
I am currently facing an issue with identical values.
My goal was to return value Y when two are identical and return N when not identical.
However:
if both are empty it also returns N instead of Y.
My code:
=if(aggr(distinct date(B_DATE_PRE_ASSEMBLY_F),ID) = aggr(distinct date(BXTERMIN_VM),ID), 'J' ,'N')
How do I include a case for Empty values?
I have already included Null values in configuration.
Thanks in advance
