Skip to Content
Former Member
Jan 10, 2017 at 11:24 AM

Count Transactions


I have an issue where the Period is not working properly and I am looking a formula that will give me a quick fix as I don't have access to the universe to change it. I tried using

=If [Date Paid] Between([1st April];[30th April]) Then Count([Transaction Reference])

this formula has validated but it is bring back the total count for the whole year rather than just the references for the transactions paid in April. Is there something I am doing wrong?