set analysis on positive/negative values

[#1]

Hi, i need to analyse some values on a chart excluding negative values.

I know I should use the set analysis but i'm not able to do this kind of formula, the basic one is Avg([GG]) and I cannot isert the set with > or <

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

Do you mean you want to get the Avg() for all values in one field except for those that are less than zero? If so, please try

Avg({< Value = {"<0"} >} Value)

That reads return the avg for all values in field Value except for those that are less than zero.

Hope that helps.

Miguel