Help creating custom column

[apesmom]

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!

[chaley]

The template for the #cost column should be something like

program: 
	v = add(raw_field('#c'), raw_field('#credit'));
	format_number(v, '${0:5,.2f}')

Using template program mode is required because the number format contains the { and } characters. Using raw_field instead of field is required because the #c or the #credit columns are themselves formatted and contain non-numeric characters.

[apesmom]

That did it! Thank you, thank you, thank you!!!!!