Multiplication of values from the "GR Ratings" and "GR Votes" columns

[Levinas2021]

Hello Everyone!

Does anyone know what formula should be used in Calibre to return in a column the final result of the multiplication of values from the "Goodreads Ratings" and "Goodreads Votes" columns?

I'm using the Goodreads metadata plugin to get Goodreads Rating and Votes into to custom columns following these instructions: https://github.com/kiwidude68/calibr...custom-columns

Thank you in advance for your support!

[ownedbycats]

This template should do it.

program:
## Change these to your own columns.
ratings = $#ratingcol;
votes = $#votecol;

## This multiplies 'ratings' with 'votes' and then formats the number to use 2 decimal points.
format_number(multiply(ratings,votes), '{0:5.2f}')

## Alternately, delete the above line and uncomment this if you want it rounded to nearest whole.
## round(multiply(ratings,vote))

Replacing the first four lines with these skips a step and pulls right from the ID columns:

program:
ratings = select($identifiers, 'grratings');
votes = select($identifiers, 'grvotes');

Here is all the available arithmetic functions for template:
https://manual.calibre-ebook.com/gen...tml#arithmetic

[Levinas2021]

It worked fine!

Thank you!