How to get value from database into line items

sharmagh · April 2020

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?

Misbah · April 2020

@sharmagh

See if this helps

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

nathan_rudman · April 2020

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

How to get value from database into line items

Best Answers

Categories