3 Replies Latest reply on Apr 10, 2018 4:09 AM by ANIL KARATAS

    Trying to replace "No Data" with NULL and 0

    Ee King Beh

      Hi All,

       

      In one of my worksheet, i drag a measure to the text label to display the values. However, this measure has no data so it causes the box i created to disappear on the dashboard. I looked into the forum and thought of trying this

       

      ZN(LOOKUP([A])) but i get this statement "results are computed for all rows. The value to use for absolute LOOKUP has not been set". What does it mean and how do I replace no data with other values?