multiple if condition

[#1]

AOA

i want to execute this statemnt as expression.

IF sum(bal_qty)>0,'up'

IF sum(bal_qty)<0,'down'

IF sum(bal_qty)=0,'No change'

so what would be the expresion for this!!!!!!!!!

i tried

if(sum(bal_qty)>0,'up','down')

its work fine on two condition up and down

how to deal with third one when sum(bal_qty) = 0

???

[kumarnatarajan]

hi,

try this one.

if(sum(bal_qty)=0,'No change',

if(sum(bal_qty)>0,'up',

if(sum(bal_qty)<0,'down',

)))

[oleg_orlov · Accepted solution]

Hello! Try something like that:

if (Sum (bal_qty) > 0,

    'up',

    if (Sum (bal_qty) < 0,

        'down',

        'No change'

    )

)

[#4]

Both answer are correct.......