6 Replies Latest reply on Dec 6, 2017 5:10 AM by Marc Chassot

    missing value for december of last year

    Marc Chassot



      I want to create a running sum per year(2016 and 2017) and display them on the same graph for visual comparison. There is no value for december 2017 but I want to display it anyway (the running sum should return 14 not 0 or null)


      I have already tried analysis -> table layout -> display empty columns

      I have already tried to add ZN() functions which has a correct effect on all columns except december 2017

      I have already tried other solutions like lookup with number of records


      Do I miss something ?


      Can anyone help me?


      Thank you