7 Replies Latest reply: Jun 25, 2018 4:06 PM by Bella Mae RSS

    Expression working intermittantly

    Bella Mae

      I have an expression which compares two fields and returns a Y or a null, it is working on some lines but not on others. I have confirmed that the two things I am comparing are the same.Capture.PNG


      This is the expression, if((aggr(max(RecordEffectiveFromDate),NSN))=(RecordEffectiveFromDate),'Y',Null())

      I have tried it with date() and date#() and I get the same result.

      Any ideas on what to try would be appreciated.