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

    Show text when value blank


      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