Basically, I want to multiply the Interest/Average by the respective months day count. This gives me only the last month, due to the Day(SUMMARY_DATE). how do I change it to make it so that it picks each month.
It will likely help if you can attach a sample QVW on this one.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.