4 Replies Latest reply on Aug 13, 2018 2:12 AM by Shruthi B S

    Query on ZN function

    Shruthi B S

      Hi People,

       

      Could you please suggest how to replace Nulls with 0. I have used ZN function here but still cannot get the expected output. I have attached workbook for reference.

       

      Eg.,

      Here I'm displaying max 3 qtrs sales for all customers. When there is no sales, i have used ZN to replace it with 0. But when i select individual customer, I'm not getting 0 in place of Null.

      I want to see below result when i select "Cust2". Please suggest workaround to achieve this.

      Qtr              Cust2

      2018Q4       1038

      2019Q1             0

      2019Q2        1416

       

      Regards,

      Shruthi