PA Calculation Fields

[riccadonna63]

Hello

I have just created a calculated field for "Remaining Work" in a
Project Analyzer OLAP report using the following formula

[Measures].[Work]-[Measures].[Actual Work]

and it works great. But what I now need to do is go one step further
and have it calculate "Where Remaining Work is greater than 0" but I
haven't had any success. I've looked at help files and on the internet
but I can't find anything to help me.

I would really appreciate any help that you can give me.

Thank you
Rosa

 

[Kevin W Flanagan]

Rosa-

See if this works:
IIf([Remaining Work]< 0, ([Measures].[Work] - [Measures].[Actual
Work]), ###) where the format is IIF(expression, true, false). In other
words check to see if Remaining Work is greater than zero, if yes then
perform your equation, if no, then replace the "###" with what you want
displayed when Remaining Work is not gretae rthan zero. Hope this helps.

Kevin

 

[riccadonna63]

Hi Kevin

Thanks for the tip. Ok I Put in this formula

IIF([Measures].[Work]-[Measures].[Actual Work]>0,
([Measures].[Work]-[Measures].[Actual Work]),false) and I get this
error message

The query could not be processed: Formula Error - Syntax Error -
unexpected end of expression.

What I'd like is for all the zero hours not to show up at all.

Any thoughts?

Thanks
Rosa

Rosa-

See if this works:
IIf([Remaining Work]< 0, ([Measures].[Work] - [Measures].[Actual
Work]), ###) where the format is IIF(expression, true, false). In other
words check to see if Remaining Work is greater than zero, if yes then
perform your equation, if no, then replace the "###" with what you want
displayed when Remaining Work is not gretae rthan zero. Hope this helps.

Kevin
--
Kevin W Flanagan, PMP
EPM Consultant

Hello

I have just created a calculated field for "Remaining Work" in a
Project Analyzer OLAP report using the following formula

[Measures].[Work]-[Measures].[Actual Work]

and it works great. But what I now need to do is go one step further
and have it calculate "Where Remaining Work is greater than 0" but I
haven't had any success. I've looked at help files and on the internet
but I can't find anything to help me.

I would really appreciate any help that you can give me.

Thank you
Rosa

 

[Kevin W Flanagan]

Try replacing the word "false" with "" (empty quotes)
--
Kevin W Flanagan, PMP
EPM Consultant

Hi Kevin

Thanks for the tip. Ok I Put in this formula

IIF([Measures].[Work]-[Measures].[Actual Work]>0,
([Measures].[Work]-[Measures].[Actual Work]),false) and I get this
error message

The query could not be processed: Formula Error - Syntax Error -
unexpected end of expression.

What I'd like is for all the zero hours not to show up at all.

Any thoughts?

Thanks
Rosa

Rosa-

See if this works:
IIf([Remaining Work]< 0, ([Measures].[Work] - [Measures].[Actual
Work]), ###) where the format is IIF(expression, true, false). In other
words check to see if Remaining Work is greater than zero, if yes then
perform your equation, if no, then replace the "###" with what you want
displayed when Remaining Work is not gretae rthan zero. Hope this helps.

Kevin
--
Kevin W Flanagan, PMP
EPM Consultant

Hello

I have just created a calculated field for "Remaining Work" in a
Project Analyzer OLAP report using the following formula

[Measures].[Work]-[Measures].[Actual Work]

and it works great. But what I now need to do is go one step further
and have it calculate "Where Remaining Work is greater than 0" but I
haven't had any success. I've looked at help files and on the internet
but I can't find anything to help me.

I would really appreciate any help that you can give me.

Thank you
Rosa

 

[riccadonna63]

Thanks Kevin.

I started from scratch and set up the OLAP report again and added a
calculated field using your formula. The formula works with "false" on
the end and therefore works based on those conditions... but what I am
trying to say is if resources remaining work is greater than 0 then
show me the number of hours for this resource on the report, if not
then hide them from the report all together.

The formula at the moment shows every resource in the global resource
pool even if their remaining work is zero.

Thanks for your efforts and help.

Regards
Rosa

Try replacing the word "false" with "" (empty quotes)
--
Kevin W Flanagan, PMP
EPM Consultant

Hi Kevin

Thanks for the tip. Ok I Put in this formula

IIF([Measures].[Work]-[Measures].[Actual Work]>0,
([Measures].[Work]-[Measures].[Actual Work]),false) and I get this
error message

The query could not be processed: Formula Error - Syntax Error -
unexpected end of expression.

What I'd like is for all the zero hours not to show up at all.

Any thoughts?

Thanks
Rosa

Rosa-

See if this works:
IIf([Remaining Work]< 0, ([Measures].[Work] - [Measures].[Actual
Work]), ###) where the format is IIF(expression, true, false). In other
words check to see if Remaining Work is greater than zero, if yes then
perform your equation, if no, then replace the "###" with what you want
displayed when Remaining Work is not gretae rthan zero. Hope this helps.

Kevin
--
Kevin W Flanagan, PMP
EPM Consultant


:

Hello

I have just created a calculated field for "Remaining Work" in a
Project Analyzer OLAP report using the following formula

[Measures].[Work]-[Measures].[Actual Work]

and it works great. But what I now need to do is go one step further
and have it calculate "Where Remaining Work is greater than 0" but I
haven't had any success. I've looked at help files and on the internet
but I can't find anything to help me.

I would really appreciate any help that you can give me.

Thank you
Rosa