customised column puzzle

[fancoir]

Hi everyone,

Hope someone can help me with a problem I'm having creating a customised column in Calibre. I have created 3 columns (#plot, #pace and #character) which each contain integer values between 1 and 5.

I now want to create a new column #score which is calculated from the average of the 3 columns. And just to complicate things I want to add a weighting of 1.5 to plot. (i.e. #plotx1.5)

This looks possible but I'm getting lost in the manual. Grateful if anyone can help out.

Thanks!

[chaley]

Something like this General Program Mode template:

program:
	divide(
		add(
			add(field('#pace'), 
			    field('#character')), 
			multiply(field('#plot'), 1.5)),
		3)

[fancoir]

Thanks Chaley!

I've been trying to get this to work for hours but was way off a solution.

One more thing - how do I format the answer to 2 decimal places?

Thanks again

[chaley]

Use the format_number function. I leave it as an exercise to work out the details.

[fancoir]

Thanks Charley - worked it out.

You've been a great help. much appreciated.