I'm baffled

[bobbydave]

This should be simple. I cannot see for the life of me what I am doing wrong.

I am trying to say

if(CVSS3 > CVSS, CVSS3,

    if(CVSS3 = '', CVSS)) as Test

So if CVSS3 is greater than CVSS, give me CVSS3,

    else if CVSS3 is blank give me the CVSS value

I cannot get the value if blank.

I've used NULL(), separated the equations and cannot get the blank value to return the other value.

Please advise.

Thanks

[Anil_Babu_Samineni · Accepted solution]

May be second condition is not the really null value?

if(CVSS3 > CVSS, CVSS3, if(IsNull(CVSS3), CVSS)) as Test

Or

if(CVSS3 > CVSS, CVSS3, if(Len(CVSS3)>0, CVSS)) as Test

[bobbydave]

I knew it was something simple.

THanks