05-13-2021 10:33 PM - last edited on 05-02-2023 10:48 AM by JackLacava
I am trying refer a intersection in member formula and apply condition based on the referenced cell.
Dim nvASP As DataCell = api.Data.GetDataCell("A#[ASP (£)]:F#No_Curr:I#None:U1#[Adjustment (Override)]:U2#None:U4#None:U5#None:U6#None:U8#None")
If nvASP.CellStatus.CellAmount = 0.0 Then
api.Data.Calculate("F#No_Curr:O#Forms:U1#Total:U2#None:U4#None:U5#None:U6#None:U8#None:I#None:A#[ASP (£)] = F#No_Curr:O#Forms:U1#Calculated:U2#None:U4#None:U5#None:U6#None:U8#None:I#None:A#[ASP (£)]")
Else
api.Data.Calculate("F#No_Curr:O#Forms:U1#Total:U2#None:U4#None:U5#None:U6#None:U8#None:I#None:A#[ASP (£)] = F#No_Curr:O#Forms:U1#[Adjustment (Override)]:U2#None:U4#None:U5#None::U6#None:U8#None:I#None:A#[ASP (£)]",,,True)
It does not consider the if-else condition and just process the first condition .
Something which i am doing wrong in here ?
Solved! Go to Solution.
05-26-2021 12:39 PM
I notice there is no END IF at the end.
05-26-2021 12:39 PM
I notice there is no END IF at the end.
10-18-2021 06:48 AM
You need to specify all pov members to get the correct datacell, in this case, origin isn't specified and the function probably returns an empty datacell with a value of 0.