How to add a Line item with a formula in a list within a module?

kdoan

I am creating an income statement module.

 

Inside the module I want to create a few line item that is sandwich within a list. 

 

List - COA, Department, 

 

Line Item - Amount

 

 

Example. 

 

5000 (A part of my COA list)

50001 (A part of my COA list)

5002 (A part of my COA list)

Cost of Good Sold (A part of my COA list)

 

Gross Profit (Line Item with a formula I want to create)

 

Expense (A part of my COA list)

6000(A part of my COA list)

etc.

 

I included a screen shot with Gross profit highlighted to show you an example. If you can show me the best way to approach this, this would be great. 

 

Screen_Shot_2019-07-17_at_3_48727.png

anirudh

Try this:
Create a new line item called COA LIS in the Full Upload COA module with the format of the COA Line item subset. Input this formula:

 

Chart of Account List.COA LIS[LOOKUP: COA]

 

Then go over to the destination module and input this formula instead:

 

Full Upload COA.Amount[SUM: Full Upload COA.COA LIS, SUM: Full Upload COA.Department, SUM: Full Upload COA.Date]

 

Let me know if this works