M
Milly
Hi guys,
I put a iif statement in a custom field that calculates % complete
using Actual Work/Work*100 but I put an iif statement that check to
make sure that Actual Work didn't equal 0. That works fine.
The big problem is that now the portfolio analyser report is no longer
filterable. It seems to be related to the formula. If I remove the
column, then I can filter the report. If I put it back in then I the
report cannot be filtered.
Would the following iif statement cause some problem with the ability
to filter a Portfolio Analyser view:
iif([Actual Work]=0, 0,[Actual Work]/[Work]*100)
This is driving me insane trying to figure it out.
Thanks for any help you can provide.
I put a iif statement in a custom field that calculates % complete
using Actual Work/Work*100 but I put an iif statement that check to
make sure that Actual Work didn't equal 0. That works fine.
The big problem is that now the portfolio analyser report is no longer
filterable. It seems to be related to the formula. If I remove the
column, then I can filter the report. If I put it back in then I the
report cannot be filtered.
Would the following iif statement cause some problem with the ability
to filter a Portfolio Analyser view:
iif([Actual Work]=0, 0,[Actual Work]/[Work]*100)
This is driving me insane trying to figure it out.
Thanks for any help you can provide.