Forum Discussion
Adina_Miclea
2 years agoNew Contributor II
Thanks for your help! It doesn't seem to work unfortunately.
We managed to do the same but in a different way 🙂 We created dynamic calcs in UD8 for the variance between the 2 periods and for the percent variance. Then created a BR that would return 1 or 2 based on the same logic:
Case Is = FinanceFunctionType.DataCell
If args.DataCellArgs.FunctionName.XFEqualsIgnoreCase("FunctionName") Then
Dim varVsPY As Decimal = api.data.GetDataCell("U8#varVsPY").CellAmount
Dim varVsPYpct As Decimal = api.data.GetDataCell("U8#varVsPYpct").CellAmount
If varVsPY >200000 And varVsPYpct >20 Then
Return 2
Else Return 1
End If
End If
However, was looking for the variance cells to be formatted. It seems not possible ...
Thanks!
Related Content
- 5 months ago