set analysis on positive/negative values

Tue, 27 Dec 2011 15:21:18 GMT

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 <

Re: set analysis on positive/negative values

Miguel_Angel_Baeyens — Tue, 27 Dec 2011 15:45:58 GMT

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