Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a question.
1. I want to get the value in sheet.
ex)COUNT({$<A_FIELD={>=Avg(A_FILED)-StDev(A_FILED)}>} FIELD)
but, an error occurs.
Please let me know how to solve it.
thank you.
G'day @PARK_JY,
I can see a couple of problems. Have a look at the Primer on Set Analysis by Henric. I think your expression is most similar to this one:
Sum( {$<Date={"<=$(=Max(Date))"}>} Sales)
So that suggests that your expression should be:
Count( {$<A_FIELD={">=$(=Avg(A_FIELD) - StDev(A_FIELD))"}>} FIELD )
(I have assumed that A_FILED should have been A_FIELD)
Cheers, Barnaby.