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
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)