How to calculate total of a grouped field
I have a table called Alerts. Each Alert has a 'type'. I'd like to calculate the # of Alerts by Type and when the # of any one alert type is greater than 10 trigger a notification. As a first s...
Forum Discussion
Thanks for the help... I've created the summary report and the Type table.... Am I correct that I then have to create a relationship between the Type table and my Alert table? With that I can create a summary field....but thats where I'm having my issues now...what is the right conditions to set for that summary field?