Availability Resources

I

Ian

Hi All,

can somebody help me with the following issue.

I'm trying to create a report with the Portfolio Analyzer
that reports on actual availability per named resource.
We're gonna use this report for assignment approvals by
managers.

My pivot contains work (planned), Availability (available
hrs based on a calendar. Now i have to add the actual
availability by adding a field that shows:
Availability - Work = Actual Availability. I probably have
to add a dimension or sth like that but don't manage to
solve this probelem.

Who can help?
 
L

L Beach

Hi Ian

This is a variation on the reply I sent to David on the same topic

Insert a calculated field into the pivot table (the little icon that looks like a calculator). You'll get the commands and options window pop up on the calculation table. At the bottom there is a list of fields you can insert reference to.

Select Availability (Total) and click on Insert Reference To. Type a minus, then insert a reference to Work (Total) and your calculation will look like this: [Measures].[Availability]-[Measures].[Work]. Then click on the change button at the bottom and your calculation will become visable in the table. This gives you the amount of remaining availability of the resources. You can play around with the fields in the calculation to get what you are looking for. Once you've inserted a caluclated field, it is added to the list of fields you can select from.

Caution: If you get a calculation where you might divide by 0 then you can use a conditional iif (test,true,false) to test for zero, but this only works when you have simple groups of infomation, the more detail, the less likely it is to work and you just end up with blanks, or you loose some of the filtering that you have selected.

Next click on the captions tab and change the caption New Total (1) to what you want it to read. Don't pick the name of an existing field otherwise it will only format the field like the exisiting field

Then click on the format tab and change the number to %. There are lots of things you can play around with here to change the look except conditional formatting

I hope this helps!
 
Top