6 Replies Latest reply: Aug 5, 2015 7:27 AM by phillip colbert RSS

    Set Analysis Help (Max)

    phillip colbert

      Hi,

       

      some set analysis help please! i'm trying to Sum a field whilst getting the Max value from another (if that makes sense)

       

      e.g.

       

      QuarterActual
      110000
      210500
      30

       

      i only want to Sum the Actual for the Max(Quarter) when the Actual > 0

      so in the above example i'd be summing the Actual for Quarter 2 = 10,500

       

      make sense?

       

      thanks in advance

       

      Phil.