07-23-2013 03:40 AM
Hello
We are trying to generate a report over the number of policies over time
We would like the number of policies per month per year, the average number of policies would the be fine as it is for seeing trend in the number policies
Regards
Michael
07-23-2013 06:24 AM
You just want a count of the policies? Any other info needed?
07-23-2013 07:01 AM
07-24-2013 03:47 AM
Yes just the number of polices, no other info needed
07-24-2013 03:49 AM
Thanks, but I am not looking for the Active policies
07-24-2013 10:02 AM
I guess I am a little confused. The statment I provided will give a count of any policy that is currently visable under policies in your NBU Console. This includes policies that have been disabled, but not ones that have been deleted.
If the SQL statment did not give you what you needed, can you clarify what you are looking for?