I’m new to this, hopefully I makes sense.
I have a report with 2 tables: INC. and T.
The INC table is trade level data. The T table is loan level data.
My goal is to subtract the total in loan amounts from the
total in trade amounts. (Sounds easy)
When I drop in the trades (from the INC table) and total
them, it works perfect.
Example: 3
trades at $1 million each. Total is
$3 million.
However once I drop in the loans (from the T table), the trade
amounts shows $1 million for each individual loan (not correct). So if there are 2 loans in each trade, the
trades are now totaling $6 million. It should still be $3m.
Please help?
IP Logged
