7 Replies Latest reply on Sep 12, 2017 5:28 PM by nancy.yang

    cannot mix aggregate and non-aggregate comparisons or results in 'if' expressions.

    nancy.yang

      Hello everyone,

      Good afternoon!

       

      Can anyone here help  me how to fix the mix aggregate and non-aggregate issue here in my calculated field?

       

      if [Rptg Dt] = today() and ([Geo Cd] = 'K' or [Geo Cd] = 'X')

      then '1-APAC: Complete through ' + STR(today())

      else '1-APAC: Complete through ' + STR(MAX([Rptg Dt]))

      end

       

      As to the calculated field above, I have error message indicating: cannot mix aggregate and non-aggregate comparisons or results in 'if' expressions.

       

      Many thanks!

       

      Nancy