Problem with dynamic label in table

[asa_runstrom]

Hi

I have problem with my dynamic labels to my coloumns. I have three columns and it work if the first columns name is dummy1 and the second coloumns name is dummy 2 and in the third column I use the labels name to set the value in the column and write [dummy1]+[dummy2] .

But now I need to do the columns name dynamic and call the first column for ='dummy1 '&'$(monthA)' and the second column för ='dummy2 '&'$(monthA) but I dont get any value in column three if I write ['dummy1'&'$(monthA)']+['dummy2'+'$(monthA)'].

Does anyone know how to solve my problem?

[stephencredmond]

Hi,

Use a dollar expansion for the name reference:

[=$('dummy1'& monthA)] + [=$('dummy2'& monthA)]

Regards,

Stephen

[#3]

Hi,

Do you use qv 10 ? if this is the case you can use the "Column" function, try Column(1)+Column(2) as value for the third column. I don't remember if this function has been added in version 10 if it was existing before.

[johnw]

RenaudCharlet wrote:I don't remember if this function has been added in version 10 if it was existing before.

I don't know when it was added, but it's been around for a long time.

[asa_runstrom]

I have tried your example but it doesn't work.

[asa_runstrom]

Hi

I use version 8.5. I can't find the "Column" function so I wonder where I can find this function.

[asa_runstrom]

Hi

I found the "Column" function i version 8.5.

Thank you for your help

Åsa