Indenting specific rolls on a straight table

[paul_ripley]

Hello

I have a PnL report and I would like to have some lines indented but not the subtotal lines.

Below is the Excel template I am using

This is what the report looks like

And this is the code below.ve tr

Specifically I have tried to add spaces using

if([Roll up] = 'Rollup', pl_line_ifrs, ' ' & pl_line_ifrs  ) as pl_line_ifrs,

But then also tried chr functions but cant seem to get them to work. Can anyone please assist

Thanks

Paul

IS_Layout:
LOAD
[code pl] as %Key_PL, 
[code pl] ,
[code groupcoa],
if([Roll up] = 'Rollup', pl_line_ifrs, ' ' & pl_line_ifrs  ) as pl_line_ifrs,
if(len(trim([Roll up]))=0,'Line','Subtotal') as pl_rollup,
pl_text_format,
pl_background
FROM [$(vPath_SourceData_XLS)\Layout_3i_IFRS_IncomeStatement.xlsx]
(ooxml, embedded labels, header is 1 lines, table is IFRS_IS_Layout);

STORE IS_Layout INTO  [$(vPath_StagingData_S2)\IS_Layout.qvd] (qvd);
Drop Table IS_Layout;

[Anil_Babu_Samineni]

May be use Dual() here

If([Roll up] = 'Rollup', pl_line_ifrs, Dual(' ' & pl_line_ifrs, pl_line_ifrs)) as pl_line_ifrs,

[paul_ripley]

Unfortunately that didn't work for me

[sunny_talwar]

Try setting verbatim = 1 at the beginning of the script

set Verbatim = 1;

[sunny_talwar]

Read here about it

Verbatim

[paul_ripley]

Ah that didn't work for me also.  I don't suppose there's anything I can put on the excel sheet to do this formatting?

[sunny_talwar · Accepted solution]

So, doing the below thing with Verbatim set to 1 did not work?

if([Roll up] = 'Rollup', pl_line_ifrs, ' ' & pl_line_ifrs  ) as pl_line_ifrs,

[paul_ripley]

Actually it did work - apologies.  Thanks for your help