Like this?

Thanks

Deepak

Hi Larry, you can create an explicit Table calculation in which you can specify the Pane.

Create this calculation, then click "Default Table Calculation" so we can define the Window across which the denominator is summed (the pane).  In Compute Using, choose Advanced:

In the view as you have it set, State is not taken into consideration, so I'll leave it out here.  Set the calculation to Address Job and Person. Click Ok.

Back on the main screen, set the calculation to be "At the level" of Person and "Restarting every" Job.

Now if we put this calculation on the view - it computes correctly:

And we can use it to calculate Actual Time * Scheduled Time %:

Workbook is attached.

Best,

Jennifer

Hmm, I think to do that you would need to use Level of Detail (LOD) calculations rather than Table Calculations.

Check these out. Calcs with FX in the title are the new calcs and use FIXED (LOD). The old Calcs have TC in the title for Table Calculation.

All you need here is the final calculation: 3. FX ActTime * Sch %.  The first two calculations are there just to show the inner results of the 3rd calc. But the first two calcs don't work well on their own - they need both Job and Person to be present in the table.  The 3rd calc is ok without Job in the Table. You can remove Job from the table to get the total minutes by person.  Depending on other fields in your data and the complexity of the view in which you use this calculation, the fixed calcs may need to be adjusted.

Workbook is attached.