I am trying to compare the columns to create a Month over Month % column and the Year over Year % column that is for every row. The period is not in date form which has led to several problems which cannot be changed and I am trying to do this in the simplest way possible. Any help would be greatly appreciated. Thank you in advanced!
9 answers
Sales Per Active = Total Sales/Total Active Accounts
Recurring Bill Pay%= no. of accounts which have set up recurring bill payments for utilities/Open Accounts
Authorized Users% = No. of authorized users enrolled/Open Accounts
Average No of Transaction = No of Transactions/Open Accounts
Here is a sample of what I am trying to create and the formulas for the calculations.
