A Portfolio Analyser Connundrum

M

Milly

Hi guys,

I've put an iif statement in a custom field that calculates % complete
using Actual Work/Work*100, if the Actual Work is greater than Zero.
This formula works fine.

The big problem is that the report is no longer can no longer be
filtered. And this seems to be related to the formula only. If I
remove the formula from the column, then I can filter the report. If
I put it back in then I the
report cannot be filtered.

Am I presenting an incorrect drill path?

This is iif statement that I'm using, would it cause a problem with
the ability
to filter a Portfolio Analyser view:

iif([Actual Work]=0, 0,[Actual Work]/[Work]*100)

Thanks, as this this is driving me insane trying to figure it out.

Thanks for any help you can provide.

Regards,

Scot
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Another Portfolio Analyser Problem 0
MS Project. Real progress of the project, % complete 1
Portfolio Analyser Problem 2
Remote stopped working in PowerPoint Presenter View 0
Incorporating the User Profile location into a document template path 1
Need some PWA help 0
Portfolio Analyser Views 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0

Top