This content has been marked as final.
Show 5 replies

Re: Getting a Maximum budget  Sum by a category  Help
Sunny Talwar Jun 12, 2017 12:36 PM (in response to Audrey Fischer)May be this
Sum(Aggr(Max, Category))

Re: Getting a Maximum budget  Sum by a category  Help
Sunny Talwar Jun 12, 2017 12:37 PM (in response to Sunny Talwar )Or this
Sum(Max)/Count(DISTINCT Category)

Re: Getting a Maximum budget  Sum by a category  Help
Audrey Fischer Jun 12, 2017 1:34 PM (in response to Sunny Talwar )The outcome was:
period spent max
2017jan R$ 17.883.779,04 R$ 419.792.066,85 2017fev R$ 11.400.290,56 R$ 530.777.270,78 2017mar R$ 19.972.635,45 R$ 413.504.165,97 I was supposed to be something around 14 mil in 2017jan

Re: Getting a Maximum budget  Sum by a category  Help
Sunny Talwar Jun 12, 2017 1:43 PM (in response to Audrey Fischer)Would it be possible to share a sample to look at?

Re: Getting a Maximum budget  Sum by a category  Help
Audrey Fischer Jun 12, 2017 3:45 PM (in response to Sunny Talwar )Sure, I'll attach it here, but I believe it´s a math problem really.. Sum(Max)/Count(DISTINCT Category)
The ideal here is to sum individually.. like ((Sum(if(Max="Orange",Max,0) / sum(if(Max="Orange",1,0)) + (Sum(if(Category="HR",Max,0) / sum(if(Category="HR",1,0)))
But it would be a huge line, because I have like 1012 category.
Tks!



