If logic in Cubeview
Hi, I am trying to build in an if statement in a cubeview (getdatacell formula) on the cell amounts. In specific:
If cellamount of CVC(col 10) > CVC(col 11) then CVC(col1) else CVC(col1).
The re...
Forum Discussion
In addition to above, I could not find a way to do if statement directly in the getdatacell. I tried to create a XFBR. I tried to value pair to hold the cellamount value and then do the if statement in a Business rule. Below my attempt, but this errors out in the cubeview as it does not recognize the CVC syntax.
Memberfilter
GetDataCell( XFBR( TTP_Paramhelper, Return_MIN_RPS_EBIT, RPS=CVC(RPS_EBIT) )):name(RPS_BR)
Business Rule:
Dim Amt As Decimal = Amt
If args.FunctionName.XFEqualsIgnoreCase("Return_MIN_RPS_EBIT") Then
If RPS < 0 Then
RPS = RPS
Else
RPS = 0
Return RPS
End If
End If
#End Region