Threshold setup for
We have developed cube view for BS level commentary to avoid the business excel and email conversation on close process. But we need suggestion on threshold setup to commentary column to allow users...
Forum Discussion
anilkpantala - My assumption is that cannot be done in Cell Format but you can try in XFBR. See an exmaple you should call this XFBR in your column.
If args.FunctionName.XFEqualsIgnoreCase("Test3") Then
Dim Cbe As String = String.Empty
Dim Msct As String = String.Empty
Dim myCell As DataCellInfoUsingMemberScript
Dim myValue As Decimal = 0
Dim sValue As String = String.Empty
Cbe = "CorpStd"
Msct = "E#E1000:C#USD:S#Actual_YTD_Periodic:T#2024M2:V#YTD:A#A1000:F#Total_Flow:O#Top:I#Top:U1#Total_CostCenter:U2#None:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None"
myCell = BRApi.Finance.Data.GetDataCellUsingMemberScript(si,Cbe,Msct)
myValue = myCell.DataCellEx.DataCell.CellAmount
If myValue > 5000 Then
Brapi.ErrorLog.LogMessage(si, "IF ----")
sValue = "V#YTD:I#Top:O#Top:F#EndBalInput:U1#None:U2#None:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None"
Else
sValue = "V#VarianceExplanation:I#Top:O#Forms:F#EndBalInput:U1#None:U2#None:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None"
Return sValue
End If
End If
I tried no luck since threshold should work based on variance % below is the column calculation for Var%
GetDataCell((Divide(CVC(VarMo), CVC(YTDCurYR)))*100):Name(VarPercentage)
expected results is If Var% > 10% only users allow to enter commentary else not.
