to calculate the number of loa records in the LOA/NLOA field. I have another field called FY that I also need to be able to restrict the equation to so it will only calcuate the LOA by the Fiscal Year in the FY field. Ie would FY=04. I would need the LOA/NLOA to count the LOA's but only for FY=04 not all the LOA's in the table.
Can anyone let me know how I can add Fy restrictions to that formula.
Thanks in advance for your help.