I have a portal which basically shows credits and expenses as well as a running balance, with a category noted for each credit/expense.
Separate from the portal i have fields with which i would like to have a running total of each category, per month.
For example if X is a category for an expense, how do i write the calulation in the 'X Total' field whereby I basically want it to total all expenses that fall under the 'category x' in the month of january 2011. Would that be an if statement? If so, how should that be written?