Thread: Column with Ratio of 2 other Columns?
View Single Post
Old 02-15-2020, 10:23 PM   #4
davidfor
Grand Sorcerer
davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.davidfor ought to be getting tired of karma fortunes by now.
 
Posts: 24,905
Karma: 47303824
Join Date: Jul 2011
Location: Sydney, Australia
Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos
You need to use "format_number":

Code:
program: format_number(divide(booksize(),add(raw_field("#pages"),1)),"{0:,.0f}")
The template editor has some details about the format string.

And using "raw_field" is a bit safer. I had an error on books with more than 1000 pages as my pages columns is formatted with commas.
davidfor is offline   Reply With Quote