Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I've a difficult situation which i want to solve in the expression and not in the script.
column A :contains calculation with average of 21.16
column B: what I want to get is the value in column A minus the high average
(average of the rows of A above the average - in this case the white rows)
Thanks in advance
'A' AVG: 21.16
High 'A' AVG: 31.09
Kindly provide Sample Apps or Sample Data !
can u try this,
create a variable = store ur max avg value in this field.
and in ur chart use field B = A - variable.
Expression is:
A - avg(total if(A>avg(total A), A))
PFA