Calculating a percentage using expressions

[#1]

Hi,

I have a straight table that has the following expressions:

1Link Advances

Advances Offline

Total Advances

I am trying to show what percentage of Advances are 1Link Advances. I tried creating an additional expression

=sum ('1Link Advances')/sum('Total Advances')*100

with no luck. Can you not reference an existing expression inside another expression? I think what I'm trying to do should be pretty simple but I'm not sure of the syntax.

Any help would be greatly appreciated.

Thanks,

Shannon

[pover]

You can refer to another column, but you don't put it in sum(). It should be like the following:

[1Link Advances]/sum([Total Advances])

And instead of multiplying by 100, just tick the show in percentage (%) in the Number tab.

Regards.

[johnw]

Yes, you can reference an existing expression inside another, either by name or by column number:

"1Link Advances"/"Total Advances"
column(1)/column(3)

As Karl says, use the number tab to display as percentage rather than multiplying by 100.