Using add(x,y) to add 2 columns
Hi,
Being driven mad here and I am sure the answer if on the forum or in the documentation but I'm going round in circles so be kind to me!
I have 2 custom columns both containing numbers and I want to display another column which adds them both up.
I have created a new column which is set to be a "column built from other columns" and into it I have tried entering many different versions of add(x,y) with varying errors!
At the moment I have tried:
{add (#a,#b)}
I believe this doesn't work as it needs a field as I get an unknown field error.
Entering the name of the custom column as follows:
{#sum: add (#a,#b)}
gives:
convert string to float: TEMPLATE ERROR could not convert string to float: #a,#b
Both input columns are integers.
I have tried lots of other variants and I am now just utterly confused!
Can someone tell me what I am doing wrong, I am sure this is a simple thing!
Thanks
Iain
|