11 Replies Latest reply on Nov 21, 2018 5:51 AM by timothy rafferty

    LOD within a LOD

    timothy rafferty

      Could somebody help me out with the attached.


      Imagine a lot of 'things' that belong to only one 'group'.  The thing can have any value.. but the group has - lets say - a 'bar'.


      Which thing has the max value ... and which thing (or things) has the max value under the group's 'bar' ...


      So.. if you have


      thing1 / thingVal = 32 / GroupA / GroupA_Bar = 20

      thing2 / thingVal = 2  / GroupA / GroupA_Bar = 20

      thing3 / thingVal = 19 / GroupA / GroupA_Bar = 20

      thing4 / thingVal = 15 / GroupA / GroupA_Bar = 20

      thing5 / thingVal = 19 / GroupA / GroupA_Bar = 20

      thing6 / thingVal = 99 / GroupA / GroupA_Bar = 20


      I want to flag thing6 as the the thing with the biggest value in the group  (that's easy... if [Thing Value]={ FIXED [Group]:MAX([Thing Value])} then 'max for group' END)


      But.. I also want to flag thing3 and thing5 (they have the max value which is 'below the bar')


      And I need it all on one worksheet (there is an 'easy' solution to split the data (see below))


      I've tried and failed a few approaches and now my brain is frazzled


      (I thought this would work.. but it gives me a rogue answer per group...... IF [Thing Value]={ FIXED [Group],[Thing Value]<[Group Bar]:MAX([Thing Value])} then "yes" else "no" end)