3 Replies Latest reply: Mar 1, 2016 6:06 AM by Sunny Talwar RSS

    Use column value in set analysis

    Fredrik Ahnell

      I have a detail list where I calculate the column "Division owner" with

       

      =FirstSortedValue({$<Portal_Division_Name=, Division=,DivisionInternalName=,DivisionName=,Portal_Division=>}Division,-Aggr(sum({$<Portal_Division_Name=, Division=,DivisionInternalName=,DivisionName=,Portal_Division=>}LineAmount_EUR),Division,[Supplier number]))

       

      And now I want to use the value in this column "Division owner" to get the value for Purcahser in my set analysis

       

      I have tried both

       

      =MinString({$<Division={'[Division owner]'}>}Purchaser)

       

      and

       

      =MinString({$<Division={$(=[Division owner])}>}Purchaser)