<< Click to Display Table of Contents >> Navigation:  »No topics above this level« TOC : Script API > JavaScript > JavaScript API > Component > Report > Method >   GetDataSetAVG

 

 

Gets the average from the given field.

 

 

 

Prototype :

 

double GetDataSetAVG

(

        string FieldPath

        [ string DistinctFieldName ],

        [ string ConditionFieldName ]

)

 

 

 

Arguments :

 

 

 

 

Reference :

 

Refer to GetDataSetValue function for how to set the field path.

 

Refer to GetDataSetSUM function for DistinctFieldName and ConditionFieldName.

 

 

 

Example :

 

//Data field (ODI name : Sample, dataset name : Orders, field name : Price)

  _TraceLn(This.GetDataSetAVG("Sample.Orders.Price"));

 

//ODI parameter field (ODI name : Sample, ODI parameter field name : TotalAmount)

  _TraceLn(This.GetDataSetAVG("Sample.OZParam.TotalAmount"));

 

//Data field (specify DistinctFieldName)

  _TraceLn(This.GetDataSetAVG("Price", "Region"));

 

//Data field (specify ConditionFieldName)

  _TraceLn(This.GetDataSetAVG("Price", "", "Flag"));

 

//Data field (specify DistinctFieldName and ConditionFieldName)

  _TraceLn(This.GetDataSetAVG("Price", "Region", "Flag"));

 

 

 

Available Events :

 

OnBind

 

 

 

See also :

 

GetDataSetSUM, GetDataSetValue