AnsweredAssumed Answered

Sub Summary Based on Date Calculation

Question asked by sccardais on Mar 7, 2014
Latest reply on Mar 7, 2014 by philmodjunk


Sub Summary Based on Date Calculation


     I want to create a sub summary report based on a date calculation.

     The attached layout has two sub summary parts.

     The first summarized by Edition.

     The second by the calculation field Survey_YYYY_Mo. This field is based on another calculation field (Date_Convert) that converts a timestamp to a conventional date. Survey_YYYY_Mo converts Date_Convert to only the year and month of the survey because I want them grouped by Year and Month to track trends.

     The goal is to identify trends for each version of the product over time based on the year / mo the surveys were taken. e.g. if three surveys were submitted in Feb 2014, their results would be summarized into a single row 2014 - 02.

     I'm sorting by Edition and Survey_YYYY_Mo but instead of getting summary data below each Edition, I'm getting one row with a question mark ? in the Survey_YYYY_Mo field. I would expect each version to have multiple rows - one row for each group of surveys by year - mo they were taken.

     Can anyone tell me what I'm doing wrong here?