Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I hv a table , and i like to display number of row on Top left conner.
Paul
Hi Paul,
Did you try =Count( Distinct PART_NO_) ?
Is the number greater by one you are getting? If so, may be that is because of null, Don't you want to supress null values?
are you using same expression to get count both places... if possible could you please post both expressions.
Paul,
First you have to modify your data model.
You never count null value.
Garry
Hi Paul,
I thought that the solution would be easier. But your's is a bit complex. I got it using a macro and variable. See attached solution.
Sub CountRow
set chart = ActiveDocument.GetSheetObject("CH230816")
set v = ActiveDocument.Variables("RowsNum")
v.SetContent chart.GetNoOfRows,trueEnd Sub
Cheers.
Thank you very much.