Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Any idea on how can I load my data based on the ROMth? Meaning that the curentbookbalance should not be loaded as a whole, instead it should be grouped by their respectively ROMth. The end product should be 12 different ROMth which represents the current book balance for that specific month. The reason for this is to get each month's balance which is calculated by last month's balance - run off amt for the current month. The graph will be shown as a stacked bar chart shown below which would also show the different products in that month.
I'm afraid I don't understand what you're trying to explain. I'm guessing you need something calculated and that involves the currentbookbalance column and then runofamt column. Can you give an example with numbers of how the number you want to calculate is calculated?
For example, to calculate Aug balance, (Aug bal = July balance - Aug Runoff) which is $2,669,342 - $1,180,198 = $1,489,144 (this should be the amount shown in the stacked bar for Aug)