Selecting Multiple Dimensions in Error

[Anonymous]

I have a list of dimensions which users can choose from to populate a table.

In the straight table chart, I have the following formula in the "Enable Conditional" field in the Dimensions tab:

=SubStringCount(Concat(_Dimension,'|'), 'Field Name')

This is causing an issue for fields with similar names. For example, I have Account Code and Allocation Account Code. When the user chooses Allocation Account Code it populates the table with the Account Code field AND the Allocation Account Code field.

I would like the table to only populate for the Allocation Account Code.

Any ideas?

Thank you,

- dave

[jonathandienst · Accepted solution]

Try something like this:

SubStringCount('|' & Concat(_Dimension,'|') & '|', '|Field Name|')

(all fields, including the first and last, are bounded by | characters)

[antoniotiman]

Hi David,

excellent Jonathan' solution.

Another way is

Your Dimension Table

_dimension,_description

AccCode,Account Code

AllAccCode,Allocation Account Code

......

Conditional Expression :

SubStringCount(Concat(_dimension,'|'),'AccCode')

Your List Box :

_description

Regards,

Antonio

[Anonymous]

Thank you for both of your responses. Jonathan's solution was most easy to apply so I went with that. Appreciate the help per usual.