Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All.
I need a KPI to sum the total sales below 25% of the average sales. The average sales % calculates as follows
avg(sales)/avg(total sales).
for example if my sales average is 100 I need to sum up all the vales below 25
I'm sure it's a aggr function but I can't get it to work
Thanks in advance
I answered my own question as follows
sum(aggr(if (Avg(Sales)/Avg(TOTAL Sales) <0.25,Sales ),Sales))
Would you be able to show what you have by sharing a sample or by showing some images?
untested but:
sum(if((avg(sales)/avg(ALL Sales)) <0.25, sales, 0))
I answered my own question as follows
sum(aggr(if (Avg(Sales)/Avg(TOTAL Sales) <0.25,Sales ),Sales))
Hi David,
why the zero at the end?
Aggregating this by sales? Not a great idea... but if it works for you... then feel free to use it
Just the false part of the If, not really necessary if Summing I suppose.