3 Replies Latest reply: May 15, 2014 10:00 AM by Bradl Vogl RSS

    Subtotal of calculated field value question

    Bradl Vogl

      Hello,

       

      I'm having a problem with subtotal in a summary.

      The excerpt below is an example of my report.

      I have "Start Date" as a key field.

      I selected Properties, Display, Insert subtotal line. Which should subtotal after each change in key value (start date). Correct?

      As you can see below, it doesn't display that way.

      What am I missing?

       

      My "Start Date" field uses the following formula:

       

      [Due Date]-((/7.5)+ 3)[/SIZE]

      /code

       

      It appears that the subtotal is including the calculated time as well as the date.

      How can I disregard the time component and only have the subtotal group by date?

       

       

       

      Start Date Due Date To Ship S/O BUSO On Hand Customer Part # LABOR U/M T-Labor CUM(T-Labor)

      2008-04-24 1:28:19 PM 2008-04-28 988 142933 142934 0 MILLER ELE 216160 0.2 0.2 3.29 1970.76

      Subtotal          3.29 1970.76

      2008-04-24 4:00:00 PM 2008-05-01 25 142275 142312 0 SEAL0001 7001652 60 60 25 1995.76

      2008-04-24 4:00:00 PM 2008-05-01 50 141169 141199 0 SEAL0001 7001671 30 30 25 2020.76

      Subtotal          50 2020.76

      2008-04-24 4:57:36 PM 2008-04-28 100 141334 141457 12 GRAN0001 CABGR-297-001 1.5 2.1 2.2 2022.96

      Subtotal          2.2 2022.96

      2008-04-25 9:20:38 PM 2008-04-30 100 125072 141714 0 WASH0001 WWVS2-W-KIT 5 5 8.33 2031.29

      Subtotal          8.33 2031.29

      2008-04-26 5:20:38 AM 2008-04-30 50 125071 141714 0 WASH0001 WWJ-W-KIT 7  5.83 2037.12

      /code

       

      Thanks, in advance, for any ideas you may have.

       

      Brad Vogl