10-31-2023 02:25 PM
The same formula works in a quick view sheet but errors out in member formaule on UD8.
If (Not ViewMember.IsAnnotationTypeViewId(api.Pov.View.MemberId)) Then
Return api.Data.GetDataCell("BWDiff(T#[Quarter(|WFTime|)]:U8#None,T#[QuarterPrior1(|WFTime|)]:U8#None)")
End If
The error that I am getting once i run the CV -
formula using in th QV sheet
GetDataCell(BWDiff(T#[Quarter(|WFTime|)]:U8#None,T#[QuarterPrior1(|WFTime|)]:U8#None))
11-01-2023 08:57 AM
This was resolved using parameters
Dim param As String = api.pov.Time.Name
If (Not ViewMember.IsAnnotationTypeViewId(api.Pov.View.MemberId)) Then
Return api.Data.GetDataCell($"BWPercent(T#[Quarter({param})]:U8#None,T#[QuarterPrior1({param})]:U8#None)")
End If