Create a formula based on UserResponse()

[former_member571143]

Am trying to create a var based on Count(Payperiod) for overall report however whenever I include the formula at row level the value reverts to the individual row. How can context be overriden? e.g. Formula is Sum(HrsWorked)/Count(Payperiod)

Where Count(Payperiod) is based on a range of dates selected from UserResponse() for a Beginning and Ending Payperiod.

Report contains record for each employee and If Count(Payperiod) = 3 but that employee may have only HrsWorked recorded for one of the Payperiods

I want calculation to use HrsWorked for each employee but I need to use the number of payperiods based on the UserResponse()s not on number of Payperiods recorded for employee.

[former_member142702 · Accepted solution]

Hi

try this syntax

Sum(HrsWorked)/(Count(Payperiod) In Report)

Regards,

Stratos

[former_member571143 · Accepted solution]

That resolves the problem. Thanks much!

Gary