synapsevampire -
Thanks I'll try that. I think it's a grouping issue. I was able to do a work around by calculating the mode for each group and storing it in a table and joining back in the report.
Trying to use the "mode" function and get the error "Summary / running total field could not be created."
Here is the code:
mode({v_mike_snf_analysis.Days},{v_mike_snf_analysis.diag#})
It is for a group of diag#, days. I need the mode (days) for each group of diag#.
Thanks.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.