Getting NA in Grand Totals-Portfolio Performance Report

[akahrim]

Hi Mark..I was getting Grand Totals few days ago, but now I am not. I toggled "Exchange Rate Adjusted" but no luck.

I have checked currency of all investments and they are "C". I have turned on "Hidden Investments and all are "C".

I have filtered out usdcad=x investment (which was showing NA in the report), it now shows 0, but Grand Totals are still NA.

Sub Portfolio and Portfolio totals are showing in the report, just the bottom line Totals are NA.

Suggestions?
Thanks
AK

[Mark]

Hi AK,

Any time you get an N/A in a report, you can use:

Help / Logs / Report Calculation...

and it should explain any N/A values in the report. If it doesn't explain the reason in this case, please let me know.

[akahrim]

Hi Mark..."option to allow summing across currencies was off", I set to on and Total was calculated, all be it with a "na" in front of Total number.

Thanks
AK

[Mark]

Hi AK,

You can leave that option off, and turn on "View / Exchange Rate Adjusted" to get totals. In this case, you do need to make sure all your "Exchange Rate" type investments are set to your default currency. This is the preferred method, so you're not summing values across currencies. For more details, see this:

https://www.fundmanagersoftware.com/faq ... encies.php