Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor II
4 years ago
Solved

If condition not working in member formula

Originally posted by Rahul Joshi

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 ?

  • Originally posted by Colin ONeill

    I notice there is no END IF at the end.

2 Replies

  • ChristianW's avatar
    ChristianW
    Valued Contributor

    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.

  • OSAdmin's avatar
    OSAdmin
    Valued Contributor II
    Originally posted by Colin ONeill

    I notice there is no END IF at the end.