how to ignore fields runtime which arent available from being considered in the calculation?

[sangs8788]

I am doing a calculation to add up all the time spent in each layer. But there are cases where few fields not existing/relevant. In that case how do i make it to consider only the fields present during runtime.

eval processing_time = Layera + layerb + layerc + layerd

Say a particular event doesnt have layerc - the processiing time isnt getting calculated. So how do i make it to ignore the fields which arent present ?

[vnravikumar · Accepted solution]

Hi @sangs8788

Try

your query...| fillnull value=0 Layera,layerb,layerc,layerd | eval processing_time = Layera + layerb + layerc + layerd

[renjith_nair]

@sangs8788 ,

Try

|eval processing_time=if(isnull(Layera),0,Layera)+if(isnull(layerb),0,layerb)+if(isnull(layerc),0,layerc)+if(isnull(layerd),0,layerd)

OR

|eval processing_time=0|foreach Layer* [eval processing_time=processing_time+<<FIELD>>]