2 Replies Latest reply: Mar 5, 2018 4:38 AM by Christophe Brault RSS

    Dimension based on a "if" condition

    Caroline Huet

      Hello,

       

      I have the following table :

       

      IDEntry date new fileEntry date old file

       

      I would like to add a new dimension : "Deleted" that will show "deleted" if the entry date in the new file is empty or if the entry date in the old file is empty. I tried to create a new dimension directly in the visualisation with the following expression :

      - =If((IsNull(Sum([New Total Date début])) OR IsNull(Sum([Old Total Date début]))),1,0)

       

      But it is not working.

       

      Where and how can I create a new dimension ?

       

      Thanks,

       

      Caroline