Hi all,
Still fairly new to Designer, I have a fairly hefty database (several hundreds of thousands of unique loans) of a portfolio of assets that updates monthly, and I'm trying to build a summary entirely with in-DB tools. My issue is this:
Thanks for the help!
-Matt
Solved! Go to Solution.
I think the easiest way is to create a new column pct_orig * previous_loan_balance
Then in the summarise in-db tool create two totals one of pct_orig * previous_loan_balance and one of previous_loan_balance
Finally use a formula in-db tool to created weighted average.
Thanks! That method did it.