Quote:
Originally Posted by zoorakhan
1. Formula encountered a error because I had word count column set up with thousand separators (eg. 123456 is shown as 1,23,456). Had to erase the format for numbers for that column and values showed up like magic. (it was magic for me as i had struggled for multiple hours with import list plugin method. your method was much more noob proof)
|
That is probably because the field is delivered to the function as a string, but because of weak typing it is treated as a number by the divide function. If your formatting for the words field was {0:,}, you can keep the separator for display but replace the comma in the formula in this manner:
Code:
program:format_number(multiply(divide(re(field('#words'),',',''),21000),divide(field('#gunning'),8)), '{0:.2f}')
Quote:
Originally Posted by zoorakhan
2. Since I have the calculated values, I was wondering if my some chance I could copy only the values (kinda like copying a cell with formula to another cell with paste ->values only in MS Excel) and delete the original column wherein the values were calculated.
The reason I m asking is I read somewhere in these forums that are columns that are calculated from other columns slow the library.
|
I don't think you will get a significant performance hit with this column since it uses general program mode, which is compiled. I believe those issues were solved quite some time ago. Just try it
If you're concerned you could always do what BetterRed suggests. You could also ask forum user chaley what he thinks, he's the wizard behind the whole template language, send him a PM with a link to my post.