On my report I have the column 'EB Attendance Cap' that displays the maximum number of times a member can attend our events in a year.
Another column 'Attendance YTD' is a summary formula column that counts how many times a member has attended our events this year to date: (RowCount) for Selected Groups, Row Group = [Account Name]
I'm trying to get a formula in the 'Balance remaining' column to count the variance of the 2 variables and can't seem to get this to work.
Any help would be much appreciated.
#Formulas
Hi Mark,
Yes, the EB Cap is a formula field (number) on the account level, the number displayed is based on each member's level.