Percentages Threshold on Variance Columns in Cube Views

Anthony_N
New Contributor

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 3

TheJonG
New Contributor III

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

 

Anthony_N
New Contributor

This worked, thank you!

JdeVera
New Contributor

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