4 Replies Latest reply on Mar 18, 2014 3:49 PM by Anders Lam

    taking max value of breakout

    Anders Lam

      Hi,

      I am trying to get a max value out of a more granular broken out calculated field.

       

      I created a calculated field which is:  the sum of hours needed / the sum of hours available.

      I then broke then out by different job types in each of my regions.

      so for example: 

      Region A has:

      Job Type 1 returning a value of 1.2

      Job Type 2 returning a value of 1.0

      Job Type 3 returning a value of 1.4

       

      Region B has:

      Job Type 1 returning a value of 0.5

      Job Type 2 returning a value of 1.2

      Job Type 3 returning a value of 1.6

       

      I want to show each Region taking the max of all my job types for that region.  In other words, what calculation do I need to get Region A to return 1.4 and Region B to return 1.6?

       

      Thanks to anyone who can help!