URLS and Null Values

[brf10043]

All,

I have a column in my data that contains a URL.  I am attempting to show "Click Here" in my table which allows the user to click the "Click Here" and then opens the URL.  The issue is that there isn't always a value in the column.

My Code is close but I get a “Click Here” when there is no URL. I tried the expression below, but still got a “Click Here” where there was no URL value.

=if(not isnull(Only({< MonthName = {$(vCurrentMonth)},[Q_Vendor Advisory URL] = {*}>}[Q_Vendor Advisory URL])),
'Click here <URL>'&Only({< MonthName = {$(vCurrentMonth)}>}[Q_Vendor Advisory URL])
)

Thoughts?

[lironbaram · Accepted solution]

try this

if (len(Only({< MonthName = {$(vCurrentMonth)}>}[Q_Vendor Advisory URL]))>2,

'Click here <URL>'&Only({< MonthName = {$(vCurrentMonth)}>}[Q_Vendor Advisory URL])
)

[brf10043]

Thanks Liron!  That worker perfectly!