Forum Discussion

Anthony_N's avatar
Anthony_N
New Contributor
3 years ago

Percentages Threshold on Variance Columns in Cube 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.

Reports
  • TheJonG's avatar
    TheJonG
    Contributor III
    3 years ago

    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