Formula Question

[AssetHound]

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?

[Mark]

Hi AssetHound,

To help understand formulas one technique is to add all the fields to a report, so you can see each component, and it will help illustrate how the formula is getting the result. So, in your Custom report, add the:

Totaldist_btw
Projected_annualincome
etc...

fields to the report also.