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



      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.