IsNull with If Upper

[mohiahmed]

Hello

I have a field "FTL_CHK_END_TO_DD_COMPLETE" which has number of blanks within the data set, however for the calculations I want to pick up the non blank which is in number format.  Struggling with few variation as can't seem to get expression correct.  Any help would be great.

If(ISNull(FTL_CHK_END_TO_DD_COMPLETE),'Null',(if(Upper(FTL_CHK_END_TO_DD_COMPLETE)<= '2','Within SLA','Outside SLA')))

[agigliotti]

let's try:

=If( IsNull(FTL_CHK_END_TO_DD_COMPLETE) or len(trim(FTL_CHK_END_TO_DD_COMPLETE)) = 0, 'Null',
if( num(FTL_CHK_END_TO_DD_COMPLETE) <= 2, 'Within SLA', 'Outside SLA' ) )

I hope it helps.

[Brett_Bleess]

Please be sure you return to your thread to either update things or close them.  If the suggestion the Partner provided worked for you, please use the Accept as Solution button on that post to give them credit and let other Members know that worked for you, if you did something different, please consider posting that and then mark it, and if you are still working on things, please leave an update, it is greatly appreciated if you close out the threads you create.

Regards,
Brett