1 Reply Latest reply on Aug 16, 2018 3:43 AM by Okechukwu Ossai

    Multiplying measure values ignoring zeros

    P B

      Hello All,

       

      With the following dataset, I would like to multiply values per day (ignoring zeros) and make a bar chart out of it per day.

        

      DateValue
      14.08.20180,95
      14.08.20180,88
      14.08.20180
      14.08.20180,9
      15.08.20180,75
      15.08.20180,69
      15.08.20180
      16.08.20180,89

       

      The following calculation would have to be applied:

      14.08.2018: 0,95 * 0,88 * 0,9 = 0,7524

      15.08.2018: 0,75 * 0,69 = 0,5175

      16.08.2018: 0,8900

       

      So the output table (on which I'll create bar chart) would look like this:

       

      DateValue
      14.08.20180,7524
      15.08.20180,5175
      16.08.20180,8900

       

      Any idea how could I achieve that?

      Thanks in advance!