on 02-02-2017 7:01 PM
Can someone translate what this formula is trying to do?
Count ({Accounts.FeeDue}, {Accounts.FeeDue}, "monthly")-Count ({Accounts.LastPaid},{Accounts.FeeDue}, "monthly")
What is the "monthly" ?
Thanks in advance for your help.
Hi Gina,
The first Count looks wrong. Monthly is being used to summarize the count per month based on a Date field rather than daily. That Date field should be the first parameter in the function. So the first {Accounts.FeeDue} field should be a date of some sort. The second Count function looks correct.
It's quite possible you have a group already on the report based on Accounts.LastPaid and is grouping by month, which is what this count will reflect.
Hope this helps,
Brian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you Brian.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.