3 Replies Latest reply: Feb 22, 2017 6:50 PM by Daniel Jenkins RSS

    Nprint Excel Report - Formula Changes when Report is ran

    Christopher Hardy

      Hi,

       

      I am trying to add up two different qlikview tables that are being brought in my Nprint excel report. Trying to add up each's daily sales.

       

      However, when I create my formlua to be = "tab1" a9+ "tab2" a9 and then run the report, the formula changes to = "tab1" a22+ "tab2" a22 once the data is brought in.

       

      Does anyone know how to write the formula so that it doesn't get effected when I run the report?

       

      My issue in pictures is attached,

       

      Thanks.