Resource Usage (Resource Plan Work vs. Project Plan Work)

[MD]

In Project Server 2007 Data Analysis... I am trying to get a total of
resource usage (work vs. capacity). This is the statement I'm using but not
getting a result.

IF([Measures].[Work]>NULL,[Measures].[Work]/[Measures].[Capacity],[Measures].[Resource Plan Work]/[Measures].[Capacity])

Pleae help me out.

 

[BruceFFIC]

In Project Server 2007 Data Analysis... I am trying to get a total of
resource usage (work vs. capacity).  This is the statement I'm using but not
getting a result.

IF([Measures].[Work]>NULL,[Measures].[Work]/[Measures].[Capacity],[Measures­].[Resource Plan Work]/[Measures].[Capacity])

Pleae help me out.

In the "MSP_Portfolio_Analyzer" we have setup to MDX to measue work
against capacity and to show the variance. These are the two
expressions we used:

CAPACITY
iif([Measures].[Work]<>NULL,[Measures].[Capacity],NULL)

VARIANCE
iif([Work]=0 or [Capacity]=0,null,IIF([Work]/[Capacity]>0, [Work]/
[Capacity],null))