Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Formula Question

General questions about using Fund Manager that do not fit into any other forum.

Postby AssetHound » Sun Jul 14, 2024 12:48 pm

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?
AssetHound
 
Posts: 61
Joined: Sun Sep 11, 2011 3:14 pm

Postby Mark » Mon Jul 15, 2024 8:39 am

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.
Thanks,
Mark
Fund Manager - Portfolio Management Software
Mark
Site Admin
 
Posts: 11558
Joined: Thu Oct 25, 2007 2:24 pm
Location: Chandler, AZ


Return to General

Who is online

Users browsing this forum: No registered users and 5 guests

FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy
Copyright © 1993-2024 Beiley Software, Inc. All rights reserved.