Skip to main content
A
Anthony_N
Newcomer
March 8, 2022

Percentages Threshold on Variance Columns in Cube Views

  • March 8, 2022
  • 3 replies
  • 0 views

Is there a way to institute a percentage threshold on variance columns for cube views? For example, Month over Month variance to be capped at 100%, if it is over 100%, then show a blank.

    3 replies

    T
    OneStream Employee
    TheJonGOneStream Employee
    OneStream Employee
    March 9, 2022

    The below would retrieve a variance and then check the cell amount.

     

    Dim objDataCell As DataCell = api.Data.GetDataCell("VariancePercent(S#Actual,S#Budget)")

If objDataCell.CellAmount > 100 Then
	Return Nothing
Else
	Return objDataCell
End If

     

    A
    Anthony_NAuthor
    Newcomer
    March 9, 2022

    This worked, thank you!

    J
    JdeVera
    Newcomer
    November 11, 2022

    TheJonG  - Your code is used on a BR and placed on the CV row/col?

    Terms & ConditionsAccessibility statement