6 Replies Latest reply on Jun 18, 2018 6:58 AM by Andreas Nilsen

    Conditional sums of a column section

    Andreas Nilsen

      Hi, I'm trying to summarize sections of a column ("Days") in a dimension ("Project"), but so far without any success. I've tried several approaches, e.g. FIXED, INCLUDE, WINDOW_SUM etc.

       

      Here's the result I want to achieve:

       

      Measure A: If the Date of the Activity Activity9 is > 1900 then I want to obtain the sum of Days for each Project, but only the sums from Activity1 to Activity9, not Activity10.

      Measure B: If the Date of the Activity Activity10 is > 1900 then I want to obtain the sum of all Days for each Project. Otherwise it should be NULL.

       

      For example, the result of Measure A should be "12" for Project4 and the result of Measure B should be "18" in the attached file. See desired result below:

       

      ProjectMeasure AMeasure B
      Project212(empty/NULL)
      Project41218
      Project51318

       

      Does anyboday know how to do this?

       

      Thanks,

      BR Andreas