Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 <
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
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