Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi friends,
Need a small help with the problem i am facing with when column(1) and column(2) has zero values
So when i using column(3) = column(1) / column(2) , it is showing ' - ' or blank, for which i am not able to use proper Traffic LED light.
Any suggestions to overcome with problem are most welcomed.
Regards,
KC
use expression lable name instead of column
Hi,
can help this?
If(Column(1)=0 and Column(2)=0, <data that you need for your Traffic LED light>, column(1) / column(2))
Regards.
copy formula for column(1) / also copy formula for colm 2 and use this expression to arrive traffic light.
Vikas
Try like:
Alt( column(1) / column(2) , 0)
Alt(Column(1)/Column(2),0)
Hi,
Anything divide by zero you will get 0, if you want to give any value for null then use Alt() like below
=Alt(1/0, 'Default Value')
OR
=Alt(1/0, '0')
OR
=Alt(Expression, '0')
Thanks all for your quick help. Really appreciate your efforts.
Regards,
KC