1 Reply Latest reply on Apr 16, 2018 5:27 AM by Christian Gohmann

    exclude latest month if overall summation is 0

    Christian Gohmann

      We have this data like below:

       

        

      CountryMonthData
      USA2018-0151,233.00
      USA2018-0211,048.00
      USA2018-03-62,281.00
      Germany2018-0112,452.00
      Germany2018-0222,356.00
      Germany2018-03-34,808.00
      France2018-0132,312.00
      France2018-0212,522.00
      France2018-0355,322.00

       

       

      So our system automatically fills the latest month with the negative summation of the previous month if there is no value yet (e.g. above USA and Germany)

      I'd like to exclude the months without valid data yet (example above it's USA and Germany for 2018-03).

       

       

      Resulting data should only be:

        

      CountryMonthData
      USA2018-0151,233.00
      USA2018-0211,048.00
      Germany2018-0112,452.00
      Germany2018-0222,356.00
      France2018-0132,312.00
      France2018-0212,522.00
      France2018-0355,322.00

       

       

      Also I can't just include negative values since there are negative values in the transaction data so it has to look at the overall by Country / Month.

       

      Thanks!