Resolving a value in an expression

[#1]

Hi All,

I have the following expression a chart:

=Count(''&DrivingTable.TABLE_NAME&'.PKEY')

where for the sake DrivingTable.TABLE_NAME is currently A.

If I add an exp. to Count(A.PKEY) i get 16. Which is correct.

but the exp. Count(''&DrivingTable.TABLE_NAME&'.PKEY') returns 0.

I know I need the DrivingTable.TABLE_NAME to resolve to 'A' before the Count expression but am not having much luck getting there.

Any ideas?

Thanks

Jamie

[spsrk_84]

Hi,

Try like this

Count( '' &DrivingTable.TABLE_NAME " &'.PKEY')

I think in your expression u have opened duoble Quotes but u didn't closed them ...

I feel that is the problem ,check it if it is not working we will try some other things.....

Regards,

Ajay

[#3]

Not sure that's it as:

=''&DrivingTable.TABLE_NAME will return 'A'

[#4]

This kind of works:

=Sum(FieldValueCount(''&DrivingTable.TABLE_NAME&'.PKEY'))

[sparur]

Hello, Jamie.

try to set your expression for FiledName to put in variable vFieldName(for example) and set value od this variable as =''&DrivingTable.TABLE_NAME & '.PKEY'

and then calculate your aggregate function: count($(vFieldName))