Adds a calculated measure of the third type to the collection of Grid
measures.
Syntax
| Visual Basic (Usage) | Copy Code |
|---|
Dim instance As TMeasures
Dim DisplayName As String
Dim Description As String
Dim DisplayFolder As String
Dim UniqueName As String
Dim Visible As Boolean
Dim value As TMeasure
value = instance.AddCalculatedMeasure(DisplayName, Description, DisplayFolder, UniqueName, Visible) |
Parameters
- DisplayName
- measure caption
- Description
- measure description
- DisplayFolder
- subfolder in Cube Structure tree where the specified measure is to be placed
- UniqueName
- a unique string identifier
- Visible
- defines whether the measure will be displayed in the Grid right after its creation
Example
| C# | Copy Code |
|---|
private void CalculatingSalesAverage(object sender, TCalcMemberArgs e)
{
if (e.CurrentAddress.Measure.DisplayName == "Sales Average")
{
ICubeAddress a = e.CurrentAddress;
a.Measure = this.Grid.Measures.FindByDisplayName("Sales Count");
int v1 = Convert.ToInt32(e.Evaluator.GetValue(a));
if (v1 == 0)
{
e.ReturnData = null;
e.ReturnValue = "N/A";
}
else
{
a.Measure = this.Grid.Measures.FindByDisplayName("Warehouse Sales");
double v2 = Convert.ToDouble(e.Evaluator.GetValue(a));
if (v2 == 0)
{
e.ReturnData = null;
e.ReturnValue = "N/A";
}
else
{
e.ReturnData = v2 / ((double) v1);
e.ReturnValue = e.Evaluator.Format(e.ReturnData, "Currency");
}
}
}
} |
| Visual Basic | Copy Code |
|---|
Private Sub CalculatingSalesAverage(ByVal sender As Object, ByVal e As TCalcMemberArgs)
If (e.CurrentAddress.Measure.DisplayName Is "Sales Average") Then
Dim a As ICubeAddress = e.CurrentAddress
a.Measure = Me.Grid.Measures.FindByDisplayName("Sales Count")
Dim v1 As Integer = Convert.ToInt32(e.Evaluator.GetValue(a))
If (v1 = 0) Then
e.ReturnData = Nothing
e.ReturnValue = "N/A"
Else
a.Measure = Me.Grid.Measures.FindByDisplayName("Warehouse Sales")
Dim v2 As Double = Convert.ToDouble(e.Evaluator.GetValue(a))
If (v2 = 0) Then
e.ReturnData = Nothing
e.ReturnValue = "N/A"
Else
e.ReturnData = (v2 / CDbl(v1))
e.ReturnValue = e.Evaluator.Format(e.ReturnData, "Currency")
End If
End If
End If
End Sub |
Remarks
Requirements
Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family
See Also