none
Hide Label and Text if Empty RRS feed

  • Question

  • I have this basic formula that adds "Tel:" to the beginning of the text but I want to hide Tel: and the number if it's empty. How can I modify it to do this?

    ="Tel:" & Fields!nphone.Value

    Thanks!

    Wednesday, July 8, 2020 3:40 PM

Answers

  • That was the reason for my original question.

    Try

    =IIF(Fields!nphone.Value Is Nothing or Fields!nphone.Value=="","","Tel:" &Fields!nphone.Value)  


    For every expert, there is an equal and opposite expert. - Becker's Law


    My blog


    My TechNet articles


    • Edited by Naomi N Wednesday, July 8, 2020 5:42 PM
    • Marked as answer by VrRotateTX Wednesday, July 8, 2020 5:47 PM
    Wednesday, July 8, 2020 5:42 PM

All replies