View Single Post
Old 04-03-2014, 02:43 AM   #2
chaley
Grand Sorcerer
chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.chaley ought to be getting tired of karma fortunes by now.
 
Posts: 12,461
Karma: 8025600
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
The template for the #cost column should be something like
Code:
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.
chaley is offline   Reply With Quote