1 Reply Latest reply on Jul 12, 2018 6:08 AM by Jim Dehner

    Help

    Roisha Pal

      Guys,

       

      IF File Date= Max([File Date]) and str([IDS])='0' THEN COUNTD([ID]) END

       

      this gives error as mixed aggregate and non aggregate , Can anyone help me with this?

        • 1. Re: Help
          Jim Dehner

          Hi

          you have a couple of issues

          in answer to the question you would need to aggregate the first File Date reference

          IF Min[File Date}= Max([File Date]) and str([IDS])='0' THEN COUNTD([ID]) END

           

           

           

          the bigger issue is that the If statement will process a record at a time and Max[file date]   will pertain to a record

           

          if you are try to match a Max date for the data set then you will need to use an LOD  like {fixed :max(file date)}   then compare to that fixed value

           

          Jim

          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.