Formula help needed

Options
Rajasekhar
Rajasekhar Member, ALL USERS Posts: 5 Occasional Contributor
in Planning & Modeling

Hi ,

I have 2 lists, List 1 and list 2.

I have a module with line items List 1 code, List 2 code and type and applies to as List1..

 

The values are as below. I have another module with applies to as list 2. I need to pull in items of Type A into line item 1 and Type B into line item 2 based on the List 2 code. Please can you help me on the formula.

Rajasekhar_0-1603256333667.png

 

 

Regards,

Rajasekhar

Tagged:

Comments

  • Rajasekhar
    Rajasekhar Member, ALL USERS Posts: 5 Occasional Contributor

    Thank you but please not the ABC, XYZ etc are all in text format. Hence the SUM function would not work.

     

    I was able to create line items in Module 1 and bring Type A and Type B items but unable to apply the SUM as all of these are in txt format and not list format.

     

    Please can you provide some work around.

Categories