FAQ 9: Reducing the number of decimal places on a share price


I am referencing the S:FDEOYVPS (end of year share price from the fund specs) item in my report and it is appearing with 6 digits behind the decimal point. Is there any way I can reduce it to 2 decimal places?


Change the function to something like the following and you should see it in dollars and cents:


The $ROUND(...;2) coding rounds it to two decimal places and the $FMT(...;3) coding puts the dollar sign in front of it. Also, please note that the above function pulls the end of period share price for fund 2. Change your actual function to whatever fund you need to pull the price for.