Has anyone tried to use Rangeavg function using Set analysis

[bimala0507]

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

[jagan]

Hi,

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

Regards,

Jagan.

[Kushal_Chawda]

Do let me know what exactly you need with required output

[bimala0507]

@

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

[tresesco]

Try:

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

[jagan]

Hi,

Try this expression

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

Regards,

Jagan.