View Single Post
Old 09-16-2014, 12:06 PM   #1
demig
Junior Member
demig began at the beginning.
 
Posts: 6
Karma: 10
Join Date: Nov 2013
Device: Kindle NT4
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
demig is offline   Reply With Quote