10 Replies Latest reply on Mar 10, 2016 7:11 AM by Gerardo Varela

    Show text when value blank

    jens.bruckmann

      Hi all,

       

      I am struggling at moment a little bit by one calculation and really hope you can point me to the right direction.

       

      The Idea I have is following. When there is no record shown in the calculation tableau is showning nothing. My idea no is I want  to see a text then.

       

      I tried to create a formular which looks like following

       

      if [Number of Records] = 0 then "Well done. Nothing in here" else [Number of Records] end

       

       

       

      Any dea how I can show the text in " " ?

       

      Thanks for your help