Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
bobbydave
Creator III
Creator III

I'm baffled

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

1 Solution

Accepted Solutions
Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

2 Replies
Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
bobbydave
Creator III
Creator III
Author

I knew it was something simple.

THanks