5 Replies Latest reply: Aug 29, 2011 6:28 PM by doschafe RSS

    Expression calculates max pass rate, how to tell other information about what was chosen as max pass rate?

      I have a somewhat complicated expression, but basically it determines the maximum PASS for any build.

       

      =if(GetCurrentField(TestDrillIn)='Wk'

                ,

                (max(aggr(   SUM(Pass),Build))),   

       

      How do I determine the Build that this max came from?  Seems as though would be simple, but I keep getting no result.

       

      Keep in mind, the above is a part of a more complicated expression that determines this information at different dimension levels.