13 Replies Latest reply on Mar 25, 2015 11:52 AM by GuyStevens

    Sub-summary by month (leading) part



      Sub-summary by month (leading) part & calculation fields


      Hi guys!

      I have this table (See attachment)

      I created a new layout (more of a report) to view this data per month and not per property:

      1. I created a new layout based on this table
      3. removed the body part (only header left)
      5. added a Sub-summary by field (leading) part and set the "period" field as break field.      
        1. data entered in the break field is always the first of the month, so 1/1/2015 or 1/2/2015, I then set display to custom -> month and year. This way I created somekind of month picker.
      7. I use the summary field seen in the attachment as fields and they work great. However, the "Total NOI%" field is nu summary field but a calculation and is messes up in the month display as you can see. The final percentage of 54% is perfect, but the display per month is messed up. How can I fix this?


      Please see this screenshot for my current layout