03-08-2022
11:23 AM
- last edited on
05-24-2023
12:57 PM
by
JackLacava
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.
03-09-2022 10:46 AM
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
03-09-2022 12:01 PM
This worked, thank you!
11-11-2022 03:36 PM
@TheJonG - Your code is used on a BR and placed on the CV row/col?