Using a Summary field as part of another formula 1

[SamLN]

Hi again

I want to use a summary field as part of a formula to calculate a variance figure.

I have a grouped by Employee number, and applied a summary of the "net hours" which sits in this group header.
I have a second field in the group header which is called "monthly hours" (which is a formula).

I would like to calculate the difference between the summary - "net hours" and the monthly hours.
but as this is a summarised field I cant get this into a formula.

Sam

 

[pmax9999]

Hi Sam

If I have understood what you need, you should be able to do it like this:

Sum({Table.NetHours}, {Table.EmployeeNo}) - {@Monthly Hours}

If this doesn't give you what you need, please post the code from your {@Monthly Hours} formula.

Cheers
Pete

 

[SamLN]

Thanks Pete, this works, thanks for your help and prompt response.
Sam