formulae is not working

OS_Pizza
Contributor III

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 -

OS_Pizza_2-1698776655112.png

formula using in th QV sheet

GetDataCell(BWDiff(T#[Quarter(|WFTime|)]:U8#None,T#[QuarterPrior1(|WFTime|)]:U8#None))

 

 

1 REPLY 1

OS_Pizza
Contributor III

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