IF(Totaldist_btw>Projected_annualincome,Totaldist_btw/OOPbasis_end*100,
Projected_annualincome/OOPbasis_end*100)
I'm trying to calculate distributions as a percentage of basis using the formula above. I'd like to get percentages for sub-totals as well as individual securities. Except for one security, which was sold prior to the report end date, it seems to be working even for other securities which were also sold prior to the report end date. Projected annual income is always completed and no distributions are recorded after the last sale date.
For the one security, I get some unusual number like 30,000% or so which seems to affect my sub-totals. I'm not sure why this happens?