Announcements
cancel
Showing results for
Did you mean:
Anonymous
Not applicable

## if condition? how it works?

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

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

hi,

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

output 0,005

10 Replies
Specialist II

Column(n) represent expression column

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

Anonymous
Not applicable
Author

little clear pls

Specialist II

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
Not applicable
Author

Specialist II

(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)

Not applicable
Author

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
Not applicable
Author

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

Anonymous
Not applicable
Author

output 0,005

Anonymous
Not applicable
Author

hi,

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

output 0,005

Community Browser