Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
sunilkumarqv
Specialist II
Specialist II

Avg,NumAvg And RangeAvg in set analysis ?

Explain in where NumAvg And RangeAvg functions uses in set analysis and diff b/w them.

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Avg is an aggregation function. Since Avg is an aggregation function it's possible to use set analysis in it.

RangeAvg is not an aggregation function, but takes a list of values instead and calculates the average over the list of values. NumAvg is a deprecated function that is being replaced with RangeAvg. The RangeAvg function doesn't support set analysis.


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

Avg is an aggregation function. Since Avg is an aggregation function it's possible to use set analysis in it.

RangeAvg is not an aggregation function, but takes a list of values instead and calculates the average over the list of values. NumAvg is a deprecated function that is being replaced with RangeAvg. The RangeAvg function doesn't support set analysis.


talk is cheap, supply exceeds demand
sunilkumarqv
Specialist II
Specialist II
Author

Given me some examples with explanation to above previous post so that's helps me ..