MobileRead Forums - View Single Post

chaley · 04-03-2014, 02:43 AM

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.

04-03-2014, 02:43 AM	#2
chaley Grand Sorcerer Posts: 12,463 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.