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!
|