[crackshot91]

Hello! I am using calibre, along with the Fanfiction Downloader plugin, to manage a relatively large library of fanfiction for offline reading. When downloading a story, two of the metadata fields that are used are "likes" and "dislikes"

I was wondering if it was possible to create a custom column that calculates the ratio of likes:dislikes? Or perhaps more simply, just divides the likes by the dislikes? For example:

a story with 112 likes and 17 dislikes would fill this custom column with a value of 6.59, while a story with 1157 likes and 22 dislikes would be sorted higher, with a value of 52.59.

Is there a way to do simple division of one column over another, and have the result in a separate column? And maybe for stories with no dislikes, instead of dividing by zero (surely a null result), give it a super high number, like 2000?

This is the best idea I can come up with for sorting stories by rating, because at the moment, all I can do is sort by the number of likes, and kinda glance at the dislikes to guess the ratio.

I'm not very good with math and formulas, so I don't know if it's even possible, but it'd be cool if I could somehow give more weight to stories with a larger number of votes, but a similar like/dislike value. For example, a story with 568 likes and 25 dislikes would somehow get a larger value than a story with 112 likes and 5 dislikes, even though the likes/dislikes ratio is similar.

I hope this post is clear enough. Thanks!