MobileRead Forums - View Single Post

MarjaE · 02-15-2020, 08:27 PM

Hi,

I'd like to set up a column tracking the ratio of size to #pages. My ideal format would be #ratio = (size*100)/(#pages+1).

The +1 is to avoid division by zero bugs when #pages is unknown.

I've looked in the manual, but the only ratios mentioned are aspect ratios.

I've looked in this thread: https://www.mobileread.com/forums/sh...t=column+ratio

And wrote this into "Template," but just get TEMPLATE ERROR

program: divide(field("size"),("#pages"+1));

So, uh, how should users build columns as ratios?

02-15-2020, 08:27 PM	#1
MarjaE Guru Posts: 937 Karma: 53902736 Join Date: Jun 2015 Device: multiple	Column with Ratio of 2 other Columns? Hi, I'd like to set up a column tracking the ratio of size to #pages. My ideal format would be #ratio = (size*100)/(#pages+1). The +1 is to avoid division by zero bugs when #pages is unknown. I've looked in the manual, but the only ratios mentioned are aspect ratios. I've looked in this thread: https://www.mobileread.com/forums/sh...t=column+ratio And wrote this into "Template," but just get TEMPLATE ERROR program: divide(field("size"),("#pages"+1)); So, uh, how should users build columns as ratios?