Assign the module name for the line item

Options
qsong1
qsong1 Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Occasional Contributor
in Planning & Modeling

Hi Community

 

I have a module with the following structure:

 

Module Name

---INPUT---

 

Transportation fee

INPUT

Meal fee

INPUT

--- CALCULATION ---

 

Trip expenses

CALCULATION

 

What I want to create a column named 'Module Name' is to display the module name; In this case, it is input and calculation (input and calculation are headlines). So basically all line items located after the headline X before the headline Y will be assigned the module name X.

 

Is there a way to deal with it without doing anything manually (for example, creating list to populate the module names?

 

Thank you

 

Best, Qianru 

Tagged:

Comments

  • qsong1
    qsong1 Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Occasional Contributor

    @Amaya Thank you so much. That works pretty well.

     

    Best, Qianru

Categories