5 Replies Latest reply: Oct 30, 2014 1:13 AM by jagan mohan rao appala

# Has anyone tried to use Rangeavg function using Set analysis

Hi:

Anyone having expertise in Set Analysis? I want to calculate Cumulative average against each Month and Year with 2 Years of Sales Data. Attached the Input file and QV file, if anyone can give an insight?

Kind Regards,

Bimala

• ###### Re: Has anyone tried to use Rangeavg function using Set analysis

Hi,

Can you explain your expected output for RangeAverage with an example.

Regards,

Jagan.

• ###### Re: Has anyone tried to use Rangeavg function using Set analysis

Do let me know what exactly you need with required output

• ###### Re: Re: Has anyone tried to use Rangeavg function using Set analysis

@

Hi Jagan/Khush:

Please find attached the result excel sheet, I would like to achieve.

Basically I am trying to calculate the Moving average, so For Jan it is to be Jan (Amount) by 1 and for Feb it will be  Jan(Amount) + Feb(Amount) /2 and so on and when the year changes it  needs to be reset.

Kind Regards,

Bimala

• ###### Re: Re: Re: Has anyone tried to use Rangeavg function using Set analysis

Try:

=RangeAvg(Above(Sum(Amount),0, RowNo()))

• ###### Re: Has anyone tried to use Rangeavg function using Set analysis

Hi,

Try this expression

=RangeAvg Aabove(Sum(Amount),0, RowNo()))

Regards,

Jagan.