1 Reply Latest reply: Dec 9, 2015 6:19 PM by Stefan Wühl RSS

    Suppress When Value Is Null breaks Expression with Total <Dimension>

      I noticed that the option Suppress When Value Is Null apperently breaks Expression with Total <Dimension>.

       

      Example data:

       

      OBJECTLEVEL1LEVEL2KPIYEAR
      AA302011
      BAB152011
      CAC152011
      DD402011
      EDE152011
      FDF102011
      GDG152011
      AA422012
      BAB162012
      CAC262012
      DD522012
      EDE202012
      FDF162012
      GDG162012

       

      When a single value of LEVEL1 is selected, I need to display all associated LEVEL2 values, combined with the YEAR and the KPI value (MAX, MIN, doesn't matter). So far, so simple.

       

      Now I need a second expression column that shows the the associated KPI value of the LEVEL1 OBJECT in the respective YEAR. I can do that using a Set expression an the Total Qualifier: =MAX({1<OBJECT={"$(=ONLY(LEVEL1))"}>} TOTAL <YEAR> KPI)

       

      Again, simple.

       

      Trouble ahead: Currently, the rows with null-Values of the LEVEL2 are dispalyed, which is not wanted. I can suppress them via the option named in the title ("Suppress When Value Is Null"). However, then, the expression breaks. Why? Any Ideas?


      See my uploaded workbook as an example.

       

      Thanks!