9 Replies Latest reply: Jan 27, 2017 2:15 AM by S Satti

# if value is '0' then call another value???

i have three fields

 Number Total elapsed time Late (mm) I150925_000156 116 - I150925_000156 2 0 I151208_000047 167184 - I151208_000047 0 0 I151208_000047 0 0 I160712_000183 73194 73074 I160712_000183 -72984 - I160712_000183 0 0 I160812_000125 3942 - I160812_000125 164 0

i want to call "late(mm)" if its not null or zero then show Total elapse time

• ###### Re: if value is '0' then call another value???

if(Late(mm)>=0, Late(mm), Total elapsed time)

• ###### Re: if value is '0' then call another value???

if(len(Late(mm))=0,Total elapsed time,Late(mm))

• ###### Re: if value is '0' then call another value???

where should i write this??

• ###### Re: if value is '0' then call another value???

if(Len([Late (mm)])=0,[Total elapsed time],[Late (mm)])

if possible can you share the error

• ###### Re: if value is '0' then call another value???

Sharma i think u copied and pasted that doesnt work

Total Elapsed time it should be like [Total Elapsed Time]  because of spaces in the column name

if u have space  in column name it should be with in the brackets

May be this can work

if(Len([Late (mm)])=0,[Total elapsed time],[Late (mm)])

• ###### Re: if value is '0' then call another value???

=if(Late(mm)=0 or null(),[Total elapsed time],Late(mm))

Regards,

Murali Mohan.T

• ###### Re: if value is '0' then call another value???

Hi Sharma,

try once the below Exp.

=if(isnull(Late(mm)),[Total elapsed time],Late(mm))

Regards

Sathish