3 Replies Latest reply: Mar 28, 2014 9:47 AM by Saradhi Balla RSS

    Conditional Sum

      I want to add two quarters on selecting a half year. The two quarters hold the value of the last month of each quarter. So basically i want to sum up the values of the last months of the quarters.

      An example:


      half-year : 1         quarters : 1               months : June (50 for say)

                                               2                            September (100 for say)


      so on selecting half year : 1 the expression column should display 150


      Any idea on how the expression should be?