6 Replies Latest reply: Sep 30, 2013 7:29 AM by Settu Periyasamy RSS

    set analysis based on sumif condition with 2 criteria

    Settu Periyasamy

      Dear All,

       

      Could you please convert the below " if " expression into sum expression. Let me explain the problem.

       

      I have 4 dimension and 2 sales value. I need to display the dimension (flexible) if the sales is greater than  0(zero).

       

      =if(sum({$<$(vComparison_Selection)>}VBRK.$(vCurrency)KZWI2)>0 and

      Sum(VBRK.$(vCurrency)KZWI2)>0,

      Sum(VBRK.$(vCurrency)KZWI2))

       

      see the below example.(base data)

      dim1     dim2     val(expression)     val1

      a          a1          100                    0

      a          a2          200                    500

      a          a3          0                        25

      a          a4          50                      75

      b          b1          55                      0 

      b          b2          0                        55

      b          b3          25                      100

       

      Result should be

       

      dim1     dim2          val          val1

                  Total           275          675

      a          a2               200          500

      a          a4                 50            75

      b          b3                 25          100

       

      Please help me on this.