IF(Distdist_btw<Projected_annualincome ,Projected_annualincome/OOPbasis_end*100 ,Distdist_btw/OOPbasis_end*100 )
The above formula gives me calculations in my report sub-totals. I have, however, some investments that paid distributions this year but have been sold -- which I didn't want in my current holdings report. I also get a bad number from the above calculation since the basis number is often less than zero. I'd like to eliminate these from my current holdings report.
If I add another IF statement to the above, I lose my sub-total calculations. I also can't seem to figure out how to eliminate these investments from my report. Any alternatives?
Thanks.