Forum Discussion

OS_Pizza's avatar
OS_Pizza
Contributor III
2 years ago

formulae is not working

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))

 

 

1 Reply

  • OS_Pizza's avatar
    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