12 Replies Latest reply on Dec 16, 2015 10:49 AM by Anna Lytvyn

    Counting days in a month to calculate totals

    Jerry Ward

      I am trying to build a calculation that will sum how many days have gone through in a month times a number.

       

      I have done DAY(#Date Table#) and then change it to an attribute.  When I break down by day of month it gives me the day.  But when I try for the month it does not sum.

       

      Example:

       

      Each day we sell 20 items, so its the number of days that have gone by times 20.

       

      Expanded by day:

       

      January

       

      1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31

       

      1*20 = 20

      2*20 = 40

       

      When I want to show just months its aggregating them all together instead of taking 31* 20 = 620 for January

       

      Jerry