1 Reply Latest reply: May 10, 2012 12:06 PM by o.kouznetsov RSS

    Find Key with min value and calc average value with that key

      Need help ))
      I want to find min value in a table, than find a key for that value and after find average value for that key
      i thought this is common taks but failed to find an answer
      1/ Variable to find key with min value
      MinString({$<HotelCost = {$(=Min(HotelCost))}>} RoomCategoryName)
      Then i put this in expressions
      =$(vHotelBaseRoom)
      2/  Then i try to calc average value with that key
      =Avg({$<RoomCategoryName={$(=$(vHotelBaseRoom))}}>} HotelCost)
      Receive NULL