View Single Post
Old 12-23-2014, 09:00 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,471
Karma: 8025600
Join Date: Jan 2010
Location: Notts, England
Device: Kobo Libra 2
You can do it with bulk metadata edit/search & replace, using a template as the source.

Here is a capture of the s/r screen.
Click image for larger version

Name:	Capture.PNG
Views:	201
Size:	44.3 KB
ID:	132834

The template is hard to see in the capture, so here it is
Code:
program: format_number(divide(raw_field('#myfloat'), 1.5), '{0:.2f}')
Change '#myfloat' to the lookup name of your column. The format_number function rounds the result to 2 places (.2f).
chaley is offline   Reply With Quote