Forum Discussion

JoseBaez's avatar
JoseBaez
Qrew Trainee
6 years ago

Is there a way to have a summary report calculate the variance of the difference between sums?

Basically I need the variance to be calculated as the following: FTE Target - FTE Sum (Filled) - FTE Sum(Open) = Variance. In which case would be  9.6 below.
Formulas and functions
reports and charts
JoseBaez's avatar
JoseBaez
Qrew Trainee
6 years ago
Hi Dan,

Correct I do have Cost Center table. I'm also am doing the math in the record but it sums the individual variances on the summary which is not the result needed.

Question - is there a way to create a formula field that captures the totals shown at the bottom of a Report Link?

i.e. pull in the total 40.3 into a separate formula field? I'm thinking as a workaround have the math show in each record..I think this will be acceptable because the report consumer has to view each record individually anyway.



JoseBaez's avatar
JoseBaez
Qrew Trainee
6 years ago
Sorry..Mark.

The variance calc in the record is missing the Filled and Opened totals for the Cost Center. Keep in mind its a sum of multiple records for each cost center. In other words, each cost center has multiple records within it...I need the sum of Total FTE (Open) and (Filled)...if I can get this in the record I'd be in business...the variance calc would work.