Showing a variable in text object

[#1]

[Inp july-Semp]:

LOAD 1 as Count,

     Locations,
     [Q2.Physician name upon their specialty]as [Physician name upon their specialty],
     [Physician Name];

FROM

[..\Data\EXCELs\Bilal-Mafraq inpatient (july - august - Sept).xlsx]
(ooxml, embedded labels, table is Sheet1);

let InpatientTotal = NoOfRows([Inp july-Semp]);

Now i want to show this in a text box, how can i do that?? do i have to create a variable in  Settings => variable overview ??

[roger_stone]

Hi

You'll need to change your statement to

let InpatientTotal = NoOfRows('[Inp july-Semp]');

but then when you create your text object, all you need in the Text box of the General tab is =$(InpatientTotal)

Cheers

Roger

[jagan]

Hi,

Try this

[Inp july-Semp]:

LOAD 1 as Count,

     Locations,
     [Q2.Physician name upon their specialty]as [Physician name upon their specialty],
     [Physician Name];

FROM

[..\Data\EXCELs\Bilal-Mafraq inpatient (july - august - Sept).xlsx]
(ooxml, embedded labels, table is Sheet1)

LET vRows = NoOfRows('Inp july-Semp');

Now, you create a text object and give the following as expression

=vRows

Hope this helps you.

Regards,

Jagan.

[#4]

I tried Roger way and it showed me in the text box a '-' sign.

I tried Jagan way and it show me empty in textbox

[jagan]

Hi,

Please check attached file for solution.

Regads,

Jagan.