Register Guidelines E-Books Today's Posts Search

Go Back   MobileRead Forums > E-Book Software > Calibre > Recipes

Notices

Reply
 
Thread Tools Search this Thread
Old 03-28-2013, 02:58 AM   #1
oelgamal
Junior Member
oelgamal once ate a cherry pie in a record 7 seconds.oelgamal once ate a cherry pie in a record 7 seconds.oelgamal once ate a cherry pie in a record 7 seconds.oelgamal once ate a cherry pie in a record 7 seconds.oelgamal once ate a cherry pie in a record 7 seconds.oelgamal once ate a cherry pie in a record 7 seconds.oelgamal once ate a cherry pie in a record 7 seconds.oelgamal once ate a cherry pie in a record 7 seconds.oelgamal once ate a cherry pie in a record 7 seconds.oelgamal once ate a cherry pie in a record 7 seconds.oelgamal once ate a cherry pie in a record 7 seconds.
 
Posts: 3
Karma: 1806
Join Date: Mar 2013
Device: laptop
Post Rounding to nearest integer in Custom Column - Hijri Year

Hello,

I have a column for the year the book was written in the Gregorian calendar, and also another column for the year in the Hijri Lunar calendar

I called the first column gyear, and the second column hyear. they are related by the simple formula hyear = (33/32)*(gyear - 622)

So made a column built from other columns, and called it hyear and gave it the following template,

Quote:
{#hyear:'multiply(divide(33,32),subtract(field('#g year'),622))'}
and it works fine, except the result is a float with 4 decimal places, and I want to round it to the nearest integer. I tried

Quote:
{#hyear:'format_number(multiply(divide(33,32),subt ract(field('#gyear'),622)),'{0:d}')'}
to do this but it does not work, it simply shows blank.

Please let me know how to do this, I am sure it is a very simple feature I simply overlooked.

Thanks

Last edited by oelgamal; 03-28-2013 at 02:53 PM. Reason: added formula
oelgamal is offline   Reply With Quote
Reply

Tags
custom columns, date, format, rounding


Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom yes/no column built from long text column Philantrop Library Management 7 03-23-2013 07:44 PM
how to move value(s) of tag column to a custom made column zoorakhan Library Management 0 12-08-2012 03:53 AM
custom date column from two state column Dopedangel Library Management 7 01-03-2012 08:20 AM
help with custom column Noughty Library Management 4 10-15-2011 05:31 AM
Can custom book data be displayed in a custom column? kiwidude Development 9 03-02-2011 05:35 AM


All times are GMT -4. The time now is 10:27 AM.


MobileRead.com is a privately owned, operated and funded community.