2 Replies Latest reply: Jan 5, 2012 5:52 AM by Olivier Marcq RSS

    How to complete a value mentionned in the expression and not in selection of a dimension


      I am designing an accounting dashboard.

      I would like to now if it was possible to display a line when a value is missing and complete line with Null or 0.


      Thank you for your anwer.





      Is it possible to have 3 lines: Dog 5 Cat 0 and Dear Null/0



      Dimension is Animal = {Dog, Cat, Fish}

      Expression is Animal_Population = sum({<Animal= {Dog, Cat, Dear} >} Animal_Count)