Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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
Customer Sales
A 500
A 423
B 150
C 200
A 400
B 100
B 120
C 130
D 500
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
May be like:
avg(Sales) - fractile(total Sales,0.5)
Try Like this: avg(Sales) - fractile(sum({1}Sales),0.5)
try this
avg(total <Customer>Sales) - fractile(total Sales,0.5)