13 Replies Latest reply on Apr 16, 2017 8:15 AM by pooja Chawala

    How to replace "No values" [Not Nulls] with N/A

    Mohita Solanki

      I am trying to create a tabular report from the database but the view has some values which are not there are for some rows.

      Instead of letting them remain empty and white, I want to replace them will N/A but it's not happening.


      I tried using ZN and Lookup together as per an answer to a similar question in vain.


      The report is something like this:


      Name     C1     C2     C3     C4

      N1         Abc    Abc             Abc

      N2                   Abc    Abc



      Name     C1     C2     C3     C4

      N1         Abc    Abc    N/A    Abc

      N2        N/A     Abc    Abc    N/A


      The table in the db does not hold the row for which there is no value eg: there is a row

      N1 C1 Value

      but no row like this.

      N1 C3 Null


      It's just not there.


      Can anyone help me?


      Thank you,