cancel
Showing results for 
Search instead for 
Did you mean: 

Help with deciphering formula please

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

former_member292966
Active Contributor
0 Kudos

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

Answers (1)

Answers (1)

Former Member
0 Kudos

Thank you Brian.