COUNTIF(AVERAGE-StDev)

[PARK_JY]

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.

[barnabyd]

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.