Data Not Pulling Into Portfolio Metrics

I'm using the Project Management Office Template set.

The data on the Portfolio Metrics sheet is not populating correctly. For example, even with the sample data that's populated the Total column is populated, but it's not breaking out the total by Category type. The '2' shown in the picture is the total. The '2' should appear under the appropriate category in the columns on the right. I renamed the categories, but did not change the sample data so I don't understand why the data isn't appearing in the appropriate column.

Any ideas?

Portfolios.pdf

Find more posts tagged with

Templates

Accepted answers

All comments

Paul Newcome

If you changed the categories, did you update the formulas in the category columns?

Liz_Snavely

I updated the formulas and after I couldn't get the correct outputs, I started over and have been testing step by step to find out what the issue was. I still haven't been able to identify the cause, but so far it seems to be working ok.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.