1 Reply Latest reply on Jun 17, 2016 9:45 PM by Dmitry Chirkov

    countd for  if for sum and a condition

    chakradhar kakani

      Hello all,

       

      I'm trying to countd for if condition can anyone please help me out it giving me error cannot mix aggregate and non-aggregate arguments with this function, here is the formula

       

      countd (if sum([No Impressions])>0 and [Reached Subscriber]='1' then [Account Number] end)

       

      can anyone help with us please

        • 1. Re: countd for  if for sum and a condition
          Dmitry Chirkov

          Since every calculation is, well, calculated per row - SUM([...]) does not make sense.

          What you need is LOD (level of detail calculation) but it would be very hard to give you an answer without seeing your data and some samples of what you'd like to see.

           

          Perhaps, all you need is to remove SUM()?

               countd (if [No Impressions]>0 and [Reached Subscriber]='1' then [Account Number] end)