I'm a new user to QV and pulling together 10 country's balance sheets/P&L's/high level results and convert each country's currency into USD to form an aggregate for overall global operations. I've been able to add all ten country's respective sheets and sum them using partial sums, however the issue arises when I try to tack on an FXR conversion to all the necessary items. Adding an FXR conversion causes the partial sum to not display, and upon diagnosis I can get it to show up provided I uncheck suppress zero-values and missing. Somewhere along the line the partial sum runs into an error with adding in an FXR conversion.
Attached my QV file. I'm sure there's a better way to do this and have it work, I just don't know what it is.
Thanks in advance!