Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
.
if(Late(mm)>=0, Late(mm), Total elapsed time)
if(len(Late(mm))=0,Total elapsed time,Late(mm))
.
if(Len([Late (mm)])=0,[Total elapsed time],[Late (mm)])
if possible can you share the error
.
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)])
=if(Late(mm)=0 or null(),[Total elapsed time],Late(mm))
Regards,
Murali Mohan.T
Hi Sharma,
try once the below Exp.
=if(isnull(Late(mm)),[Total elapsed time],Late(mm))
Regards
Sathish