Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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