Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am trying to aggregate the values based on one column , it is working for one row where the aggregated column is repeating twice .
I have given below expression for this :
if (level =3, aggr(sum(a+b),column1)
kindly could anyone help me here
Thanks in Advance ,
Regards,
Tejeswari
Would be helpful if you provide a few sample rows and expected outcome here. There's nothing inherently wrong with the syntax that I can see, but without an understanding of what you're working with and what you're trying to achieve it's hard to be sure. That said, it is a bit unusual to see an un-aggregated aggr() function contained within an if() function - this is usually not what people are trying to achieve.