Percentages Threshold on Variance Columns in Cube Views

[Anthony_N]

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.

[TheJonG]

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]

This worked, thank you!

[JdeVera]

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