Quote:
Originally Posted by han_32
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
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