Skip to main content
Newcomer
Mar 8, 2022 4:23 PM UTC

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.

3 replies

Employee - Guide
Mar 9, 2022 3:46 PM UTC

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_NAuthor
Newcomer
Mar 9, 2022 5:01 PM UTC

This worked, thank you!

Member
Nov 11, 2022 8:36 PM UTC

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