Add Field Total for Date Range
Hello, We are trying to create a field, not a report, that adds up the Principal Balance for a given month. Each record is a loan. So for example, the new field name would be January Funded and...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIt is unclear to me where you want these totals to reside. Perhaps what you need is a table of months which are loaded up from excel for the next 20 years. The key field could be a date field of the first day of the month. Then you can have a relationship back to the load record where the reference field is a formula for the first day of the month.
But I am not really understanding the business purpose of your request right now. If I understood that better I might be able to suggest other solutions.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
But I am not really understanding the business purpose of your request right now. If I understood that better I might be able to suggest other solutions.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
One of the main purposes is for commission for sales reps. We have a budget every month. We need to reference the Budget fields to see if January is over or under budget and then pay accordingly. Ideally, we will create a field called "Commission Total" that applies the commission formula to the total amount funded for that month (For example- If Jan Funded < Jan Budget, Jan Funded * 0.005)
Until we know what the number is for each month, this is impossible for us to figure out
------------------------------
Gelo
------------------------------
Until we know what the number is for each month, this is impossible for us to figure out
------------------------------
Gelo
------------------------------
- MarkShnier__YouIs the budget per sales rep? Or overall for the company.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- The budget is overall for the company
------------------------------
Gelo
------------------------------- MarkShnier__YouThen I suggest setting up the table where the individual months are listed like I described above. Just enter a month or two to see if you can get the relationship working.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------