if condition? how it works?

[Anonymous]

if(1/coloumn(2)/coloumn(3)*100)>0,1/coloumn(1)/coloumn(2)*100,0)

[sivarajs]

Column(n) represent expression column

n=1 means first expression-> column(1) etc...

[Anonymous]

little clear pls

[sivarajs]

If you have 4 expression in your chart, if you want to use first expression in second expression you dont want write whole expression again . You can use column(1) in second expression

This will gives values of first expression in second.

[Anonymous]

that i understood what about 1/coloumn(2)    i  want about  1/ here?

[sivarajs]

(1/column(2)/column(3) * 100 ) >0 - dividing 2 and 3 expression, result value divided again by 1  . if this value greater than 0 then it will give result (1/column(1)/column(2)

[#7]

Hi,

if(1/coloumn(2)/coloumn(3)*100)>0,1/coloumn(1)/coloumn(2)*100,0)

here we get the values for  column(2) and column(3) suppose here we got the values 100,200 for column(2) and column(3)

here lokks like this if(1/100/200*100)>0,1/100/200*100,0)

[Anonymous]

expression ouput what?
if(1/100/200*100)>0,1/100/200*100,0)

[Anonymous]

output 0,005

[Anonymous · Accepted solution]

hi,

if(0,005>0) then 0,005  else 0

output 0,005