View Single Post
Old 08-31-2011, 01:15 PM   #142
Man Eating Duck
Addict
Man Eating Duck juggles neatly with hedgehogs.Man Eating Duck juggles neatly with hedgehogs.Man Eating Duck juggles neatly with hedgehogs.Man Eating Duck juggles neatly with hedgehogs.Man Eating Duck juggles neatly with hedgehogs.Man Eating Duck juggles neatly with hedgehogs.Man Eating Duck juggles neatly with hedgehogs.Man Eating Duck juggles neatly with hedgehogs.Man Eating Duck juggles neatly with hedgehogs.Man Eating Duck juggles neatly with hedgehogs.Man Eating Duck juggles neatly with hedgehogs.
 
Posts: 254
Karma: 69786
Join Date: May 2006
Location: Oslo, Norway
Device: Kobo Aura, Sony PRS-650
Quote:
Originally Posted by han_32 View Post
It works - or I think so, I did not notice any counts changing, but it works. And now, for yet another bug (sorry) is there any chance we can put an if in the formula, so the formula is only done if the word count is not empty? As it is the new column is calculating 0 to all records with empty word (and page count). Itīs not a big deal, asking just in case because it would be my next tweak, but do not know how.
Try this (put something between the quotes before the last parentesis if you want something else than the empty string):
{#word:'test($,re(divide(add($, 500) ,1000),'\..*','k'),'')'}

Another issue, btw, is sorting. If you omit the suffix you can enable sorting by number, but there is no "sort numerically"-option if the field contains any letters.

Quote:
Originally Posted by han_32 View Post
And donīt worry, I would never multiply temperature by word count! (though it would be funny, what would be the entropy of each book. hmm)
Could be dangerous. My copy of War and Peace would be hot enough to fuse even heavy elements, with unpredictable results
Man Eating Duck is offline   Reply With Quote