Forum Discussion
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!
Can you provide more detail about the dynamic calcs on UD8?
Related Content
- 6 months ago