8 Replies Latest reply on Sep 11, 2018 5:18 AM by Anupam Mehta

    showing zero with strings

    Maximilian Rettig

      Hi,

       

      i am trying to show the "zero data" when comparing string.

       

      At the moment i am using this formula:

       

      IIF(CONTAINS([Labels],"reopen"),[Labels],NULL)

       

      But it is not showing zero, when the label is not contained, it only shows blank.

       

      I want to display it as 0,00%

       

      Thanks in advance.

       

      KR

      Max