0 Replies Latest reply: Jun 27, 2016 3:07 AM by Viresh Kolagimath RSS

    nPrinting formulas

    Viresh Kolagimath

      Hi Guys,

       

      I am using nPrinting formula to calculate sum of sales. My data looks like below.


      Product
      1 - jun1-May
      Printers58
      Scanner92

       

      My formula looks like =Sum(1-jun) and =sum(1-May). Now it give me the correct values but whenever there is change in the column headers, i am not getting the results as expected. Suppose 1-jun changes to 1-July and 1-May changes to 1-jun.

       

      How to use formulas in this kind of situation. Let me know if you need any other details.

       

      Regards,

      Viresh