0 divide by 0

[#1]

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

[arulsettu]

use expression lable name instead of column

[Anonymous]

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.

[vikasmahajan]

copy formula for column(1) / also copy formula for colm 2    and use this expression to arrive traffic light.

Vikas

[tresesco · Accepted solution]

Try  like:

Alt( column(1) / column(2) , 0)

[antoniotiman]

Alt(Column(1)/Column(2),0)

[jagan]

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

[#8]

Thanks all for your quick help. Really appreciate your efforts.

Regards,

KC