Testing for Null Value For a Label

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I am using the following label using a URL field  to show a label.  Mark was kind enough to help with this.  Can I hide the label where the Sales Data is returning Null. 

var text Words = "Show Store Dev History and Sales";
var text URL = [Sales Data];

"<a class=\"Vibrant Primary\"a href=" & $URL & ">" & $Words & "</a>" // makes blue
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,132 Points 3k badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of John Thomas

John Thomas

  • 1,062 Points 1k badge 2x thumb
var text Words = "Show Store Dev History and Sales";
var text URL = [Sales Data];
If(Length($URL) =0, "Null", "<a class=\"Vibrant Primary\"a href=" & $URL & ">" & $Words & "</a>" )

I hope this will solve your issue !!
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,132 Points 3k badge 2x thumb
Many thanks for your kind help.