3 Replies Latest reply: May 2, 2017 5:42 PM by Wallo Atkinson RSS

    NPrinting - Excel Template - Table Object - Add the calculated column

    amko sara

      I am using NPrinting 16.3 and would like to use calculated columns as I see here:

      Add the calculated column

      Select the first cell on the right of the field tags.

      Insert the formula =[@[Total Sales]]-[@[Gross Profit]].

      Excel will automatically add this new column to the table.

      Add Cost as a column heading.

      https://help.qlik.com/en-US/nprinting/17.3/Content/ExcelReports/HowMakeCalculatedColumnExcelReports/Make-Calculated-Colu…

       

      How can I use this kind of feature with Right() Excel function choosing part of adjacent column in excel template

      and table object Not using Levels but table object and have it populated for all rows.

       

      Thanks,

      Amko