How to get value from database into line items

Highlighted
Contributor

How to get value from database into line items

Hi,

 

I have a source module where I have raw data (Rows: Flat list of Row Numbers and Columns: All the line items). Line Items: Funds formatted as Fund List, Trans Type formatted as TT list (Investment, Commitment, Proceeds) and Transaction amount.

 

In my target module I have funds as row dimension and Amount as a line item and i want to sum Investment per Fund, How it can be done?

 

 

 

 

 

2 REPLIES 2
Highlighted
Master Anaplanner/Community Boss

Re: How to get value from database into line items

@sharmagh 

 

See if this helps

 

Module 1 Transaction Amount[SUM: Module 1.Funds]

Highlighted
Community Boss

Re: How to get value from database into line items

you can do a SUM:
source.transaction amount[SUM:source.fund]

Nathan Rudman, Anaplan Model Builder