How to set the number of decimals in a custom column

[sekhemty]

I have setup a column to evaluate the approximate time required to read a given book, it is a column generated from other columns, and it is based on the word count.

This is what I have done right now:

{#hours:'divide(field('#words'), 250)'}

it works fine, except that I'd like to remove or set a limited number of decimals; having this column say that I need 15 hours makes sense, I don't really need to know that it really is 15.632643

[BetterRed]

Originally Posted by sekhemty

I have setup a column to evaluate the approximate time required to read a given book, it is a column generated from other columns, and it is based on the word count.

This is what I have done right now:

{#hours:'divide(field('#words'), 250)'}

it works fine, except that I'd like to remove or set a limited number of decimals; having this column say that I need 15 hours makes sense, I don't really need to know that it really is 15.632643

Assuming #hours is a floating point number, try setting the format in the column definition to something suitable - e.g. {:+.2f}.

Useful link ==>> Python String Format Cookbook

BR

[chaley]

Use something like

program: format_number(divide(raw_field('#words'), 250), '{:0.2f}')

with the appropriate changes for your variables and the number of decimals you want. You need to use raw_field if #words has a template that converts it into a string.

[sekhemty]

Thank you for the suggestions!