GetDataCell Types

There are several GetDataCell expressions. You can find a complete list under OnePlace > Dashboards > Application Reports > Application Reports Dashboards > Report Groups > Application Analysis.

  • Variance: Calculate the difference as a ratio between two scenarios using the [Variance] function in a GetDataCell expression.

    For example: GetDataCell(Variance(S#Scenario1,S#Scenario2)):Name(Variance)

  • Variance %: Calculate the difference as a percentage between two scenarios using the [VariancePercent] function in a GetDataCell expression.

    For example: GetDataCell(VariancePercent(S#Scenario1,S#Scenario2)):Name(Var %)

  • Better or Worse: Calculate the difference between two scenarios while considering account types using the [BWDiff] function in a GetDataCell expression.

    For example: GetDataCell(BWDiff(S#Scenario1,S#Scenario2)):Name(BW Diff)

  • Better or Worse %: Calculate the difference as a percentage between two scenarios while considering account types using the [BWPercent] function in a GetDataCell expression.

    For example: GetDataCell(BWPercent(S#Scenario1,S#Scenario2)):Name(BW %)

  • Ratio: Calculate the ratio between two scenarios using the [Divide] function in a GetDataCell expression.

    For example: GetDataCell(Divide(S#Scenario1,S#Scenario2)):Name(Ratio)

  • Difference: Calculate the difference between two scenarios using the [Subtraction] function in a GetDataCell expression.

    The example that appears when you double click this expression in Member Filter Builder: GetDataCell(S#Scenario1-S#Scenario2):Name(Difference)

  • Sum: Calculate the sum of two scenarios using the [Addition] function in a GetDataCell expression.

    For example: GetDataCell(S#Scenario1+S#Scenario2):Name(Total)

  • Custom Function (Condensed Syntax): Call a Finance business rule using the [BR#] function in a GetDataCell expression.

    For example: GetDataCell(BR#[MyBusinessRuleName, MyFunctionName]):Name(Custom Function)

  • Custom Function: Call a Finance business rule using the [BR#] function in a GetDataCell expression. For example:

    GetDataCell(BR#[BRName=MyBusinessRuleName,FunctionName=
    MyFunctionName]):Name(Custom Function)

  • Custom Function with Parameters: Call a Finance business rule using the [BR#] function in a GetDataCell expression. For example:

    GetDataCell(BR#[BRName=MyBusinessRuleName, FunctionName=MyFunctionName, Name1=Value1, AnotherName=[Another Value]]):Name(Custom Function)