3 Replies Latest reply: Jun 21, 2011 5:11 AM by babushka RSS

    Trying to get the name of the highest company name in the hierarchy when a certain condition is fulfilled

      Hi,

       

      I'm trying to fill the company names in the lower hierarchies from where the first criteria LineNum = 1.

       

      So if LineNum = 1 on Company D then the NewCompanyName should be D,

      If LineNum = 0 on Company H then the NewCompanyName should be a company for each existing company on every level meaning rows for  A,B,D,H

       

      Basically I want to check if LineNume = 1 then grab the the CompanyName for that row and use it, otherwise use the CompanyName as is.

       

      Sorry about the bad explanation

       

       

      The example is just a test I started with.