Auto Numbering in Text Object

[santhoo_san]

Hi,

I have a tex Object with multiple project names. I want to put auto serial number for project names withing the text object. Can anyone help me in solving this. I am attaching a sample file for quick reference.

Regards,

Santhosh

[flipside]

Hi Santosh,

It might be easier to use a straight table chart with Project Name as the Dimension and RowNo() as the Expression, then just drag the Expression to the left of the dimension and format the table without totals, headers etc..

flipside

EDIT: Which I see you have already done - ignore this!

[flipside · Accepted solution]

The closest I have got is ...

=concat(distinct FieldIndex('Project Name',[Project Name]) & ' ' &[Project Name],'

',FieldIndex('Project Name',[Project Name]))

... but this will be the order the data is loaded, not alphabetical unless you sort this in the script. Also the numeric value is fixed against the location (not sure if this is what you needed).

flipside

[#4]

Hi,

Check the attachment.It may help you.

Regards

Kumar

[santhoo_san]

Hi flipside,

Thank you....

Regards,

Santhosh

[santhoo_san]

Hi flipside,

Can we use set analysis for Project Name to filter the project names based on some criteria in the solution provided?

=concat(distinct FieldIndex('Project Name',[Project Name]) & ' ' &

[Project Name]   // want to filter this field

,'

',FieldIndex('Project Name',[Project Name]))

Regards,

Santhosh

[flipside]

Yes, you can use SA with the concat function, such as  ...

=concat({<[Project Name]={'B*','K*'}>} distinct FieldIndex('Project Name',[Project Name]) & ' ' &[Project Name],'

',FieldIndex('Project Name',[Project Name]))

... to return only names beginning B or K, for example.

[flipside]

For a slightly different result, where the Project Name numbering ISN'T fixed, and will change based on selections, you can create a variable (named Projects2 in my example) as this ...

=';' & concat([Project Name],';')

... then when building the text string for the text object, count the number of delimiters (';' in my example) prior to the field in the variable list to identify its position ...

=concat(SubstringCount(Subfield(Projects2,[Project Name],1),';') & ' ' & [Project Name],chr(10), SubstringCount(Subfield(Projects2,[Project Name],1),';'))

flipside