1 Reply Latest reply on Jan 24, 2014 12:09 PM by Matt Lutton

    presenting results in a single row

    Tamar Ben Bassat

      I'm trying to show the average sales per work day.

      I managed to create the calculation by calculating a running total of the sales for the month and dividing it the the by the number of workdays up til this point.

      This all works fine. but I want to show the results side by side and not in 2 rows.

      When I remove the day pill, the calculation stops working.

      Here is my calculation:

      running_sum(SUM([invoice_line_tbl (sales.invoice_line_tbl) (rsdbbiprototype) Extract].[adjusted_pounds]))/sum(zn([daycount]))

      which works fine as long as I display the day on the row shelf.

      average per work day in 2 rows.PNG.png