Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
if(1/coloumn(2)/coloumn(3)*100)>0,1/coloumn(1)/coloumn(2)*100,0)
Column(n) represent expression column
n=1 means first expression-> column(1) etc...
little clear pls
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.
that i understood what about 1/coloumn(2) i want about 1/ here?
(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)
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)
expression ouput what?
if(1/100/200*100)>0,1/100/200*100,0)
output 0,005
hi,
if(0,005>0) then 0,005 else 0 |
output 0,005