2 Replies Latest reply on Aug 31, 2018 6:20 AM by MANOJ PRABHAKAR

    How to do this Percent of total calculation

    MANOJ PRABHAKAR

      How to do this Percent of total calculation

       

      First approach is working fine, but the null values are not showing as zero and zero %

      PFA:Sheet1.jpg

       

      Second approach for null values to show as 0:

      Used the below formula,

      Sales = zn(lookup(COUNTD([Id]), 0))

       

      for null values zero is showing up, but for null % values the 0% is not showing up

      PFA:Sheet2.jpg

       

       

      Thanks,

      Manoj