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

[#1]

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/...

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

[Lech_Miszkiewicz]

please attach your xls template and maybe xls with what you are trying to achieve. That would help recognise your problem better.

on the other hand i am not sure whether you can refer to table object as such. Excel calcualtion is done on row level so creating new calculated column has be done on the same level.\

regards

Lech

[#3]

If I use =right(B2,2) function in my Excel template Table Object
only first row in Column C gets populated as a result of excel formula not all rows

How can I get all rows in Column C to be populated?

Column A	Column B	Column C
Vendor	Week	Year
HP	W35-16	16
HP	W35-13
HP	W36-16
HP	W36-16
HP	W37-17
HP	W37-16
HP	W38-15
HP	W38-16
HP	W39-14

Thanks

[Anonymous]

Not sure what you're asking.

It seems to work fine for me to just put it within a level.