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

    Olivier Marcq

      Hello

      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.

      olivier

       

       

      Example:

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

      where

       

      Dimension is Animal = {Dog, Cat, Fish}

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