2 Replies Latest reply on Nov 10, 2016 6:52 PM by Sherzodbek Ibragimov

    Displaying Null Values and Calculating the % Total in one formula?

    d Vermaak

      Hello all,

      I am using this formula: ZN(LOOKUP(SUM([Number of Records]),0)) so that I can display Null values in one of my calculations.

      However, I need to run an additional table calculation that displays the % of total instead of just the values themselves.

       

      How do you do this? Being the that Lookup formula above is already a table calculation, am i able to run an additional table calculation the calculates the percent total? If not, is there way I can modify the formula so it displays null values (like in the 2017 column below) AND calculates the % total?