Help Formatting Custom Column

[astarinlife]

I built a custom column and got that to do what I intended but the resulting number is probably 15 to 20 digits long. I'm trying to shorten it to just one digit after the decimal (0.1). I have two sets of code that do what I want that I will post in case one works better with formatting. I've looked around to try figuring it out and it seems like {0:.1f} should do what I want, but I have no clue where it would go. Any help is greatly appriciated!

{#kudos:'divide(multiply($, 100), field('#hits'))'}

program:
	kudos = field('#kudos');
	hits = field('#hits');
	percent = multiply(kudos, 100);
	divide(percent, hits);

[allanahk]

Try this:

program:
	kudos = field('#kudos');
	hits = field('#hits');
	percent = multiply(kudos, 100);
	format_number(divide(percent, hits), '{0:.1f}')

It's always fun playing around with custom columns The calibre template language is a big help

[astarinlife]

Unfortunately that just shows the solution followed by the entire code written out. This is where I was getting stuck. I've been reading through that page and I've been trying things but I'm still suck between finding the right thing to do what I want and how to properly use it to make it work. Thank you for the suggestion though!

[astarinlife]

Never mind! It was missing a ; at the end. It works perfectly now!

[allanahk]

Originally Posted by astarinlife

Never mind! It was missing a ; at the end. It works perfectly now!

Whoops that was my mistake I'm glad you got it sorted!

For future reference, when you're editing a custom column and things aren't working I find it helpful to open the Template Editor or whatever it's called (which for some reason isn't really advertised anywhere on the help page...)

To access it, just highlight a book row in your library and click on the custom column entry (as if you were going to edit the entry if it was a simple column like title, author etc) and the editor should pop up and look like the attached pic. It updates in real time so you can play around with the coding to get it to work