Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
[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 ??
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
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.
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
Hi,
Please check attached file for solution.
Regads,
Jagan.