Using add(x,y) to add 2 columns

[demig]

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

[chaley]

To use add in the way you indicate you must use general program mode.
Try something like

program: add(field('#a'), field('#b'))

[demig]

Brilliant that's worked perfectly

Many thanks

Iain