Skip to Content
avatar image
Former Member

Help with deciphering formula please

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 02, 2017 at 07:29 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 02, 2017 at 09:43 PM

    Thank you Brian.

    Add comment
    10|10000 characters needed characters exceeded