Division by Zero!

[#1]

I'll give an example: sum((Kill + Asist) /( Dead )), how do I do the same expression when Dead field is 0? When Dead field is 0, just  sum(Kill + Assist).

I need to do this in text object.

Thanks.

[datanibbler]

Hi Igor,

just put it into an IF_condition to use the neutral number 1 in case Dead=0 like

>> sum((Kill + Assist) / IF(Dead<>0, Dead, 1)) <<

[Aurelien_Martinez]

Hi,

You can use Alt() function, like

Alt(sum((Kill + Asist) /( Dead )), sum(Kill + Assist))

Aurélien

[Anonymous]

Hi, 

You can try

if(Dead=0,sum(Kill + Assist),sum((Kill + Asist) /( Dead ))))

[#5]

Thanks guys!

but Jannet's response worked best!

[MK_QSL]

Alt((Sum(Kill)+Sum(Asist))/Dead,0)

[MarcoWedel · Accepted solution]

Sum((Kill+Asist)*Alt(1/Dead,1))

[#8]

Thanks, very useful post and great answers,

If your query is resolved, mark it with correct answer!

Regards,

Kuldeep