This content has been marked as final. Show 3 replies
I am trying to work out how to refer to a all records for a field instead of the components.
As an example I have records similar to this
what I want to do is work out the difference between the average sales for one customer against the fractile of the total data set. As an example
avg(Sales) - fractile(Sales,0.5)
The issues is that I want the fractile of all the sales for the total data set not for that customer. How would I structure this expression?
Thanks in advance