I am running into an issue when it comes to splitting commissions for my reps. I have three fields on my subscription object called "Account Manager 1", "Account Manager 2", and "Commissionable MRR". I created a report that shows each rep's commissions for the end of the month. I need a calculated field in my report that will split the "Commissionable MRR (in dollars)" if there the "Account Manager 2" field is not blank.
For example. Rep 1 sells a deal, rep 2 helps, total commissionable MRR is "$500". I need this field on the report to show me that "Split MRR" is "$250". This way I can sum the report by the "Split MRR" and therefore give my reps the correct numbers.
Thanks!
Stan
2 answers
Getting calculated fields in reports
I've found that it's far easier to add a calculated field to a query grid than it is to add one to a report. So when your report needs to include calculated values based on entries in a table, create a query, enter the calculated field as part of the query, and use that query as the basis for your report. Figure D shows what the Report Wizard looks like when I select this sample query as the basis for a new report.
Enter your calculated field as part of the query. When you launch the report wizard, use the query for the basis of the report, not the original table.
Please go through it
https://techrepublic.com/article/use-calculated-fields-in-access-queries-and-reports/
