ou can most definately use aggregate functions. What you need to to is to add the SUM or whatever function you need to the applicationContext-semanticLayer.xml. Add an 'entry' in 'defaultSQLGenerator' with the function you would like to use and, then use it in the domain designer for a calculated field