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.
Forum Discussion
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