View Single Post
Old 04-02-2014, 09:55 PM   #1
apesmom
Wizard
apesmom ought to be getting tired of karma fortunes by now.apesmom ought to be getting tired of karma fortunes by now.apesmom ought to be getting tired of karma fortunes by now.apesmom ought to be getting tired of karma fortunes by now.apesmom ought to be getting tired of karma fortunes by now.apesmom ought to be getting tired of karma fortunes by now.apesmom ought to be getting tired of karma fortunes by now.apesmom ought to be getting tired of karma fortunes by now.apesmom ought to be getting tired of karma fortunes by now.apesmom ought to be getting tired of karma fortunes by now.apesmom ought to be getting tired of karma fortunes by now.
 
apesmom's Avatar
 
Posts: 2,535
Karma: 24702524
Join Date: Apr 2011
Device: Boox Nova Air, Galaxy Note 10
Help creating custom column

I'm trying to create a new column to adds 2 other custom columns together.
Existing custom column 1 is 'c' and is a float formatted as ${0:5,.2f}
Existing custom column 2 is 'credit' and is also a float formatted as ${0:5,.2f}

The new column is to be named 'cost' and should add columns c + credit and format it ${0:5,.2f}

I assume I want to use Column type "Column built from other columns"
but I can't seem to find the proper syntax for my Template. I keep getting TEMPLATE ERROR: Invalid Conversion Specification.

So far my template looks like this: {#cost: 'add(#c, #credit)'}

I haven't even attempted to add the formatting yet.

Any help is greatly appreciated. Thanks!
apesmom is offline   Reply With Quote