Skip to main content
Question

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

  • June 5, 2019
  • 0 replies
  • 141 views
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.


    This topic has been closed for replies.

    The only way to do this would be to have a table of Cost Centers (which you may already have) and summarize up the detail records for Filled and Open.

    Then just have s simple Table Report of Cost Centers and do the math on the Cost Center Record.
    • JoseBaez
    • Author
    • Registered
    • June 10, 2019
    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.



    Terms & ConditionsAccessibility statement