11 Replies Latest reply: Nov 13, 2015 12:55 AM by Tamil Nagaraj RSS

    Replace empty field by the word others

    Hasvine Dhurmea

      Hello All,

       

      Could you please help me in replacing the empty space with the word others.

       

      I tried the mapping but it is not working:

       

      mapservicestatus2:

      mapping load * inline [

        raison_refus_rendez-vous,Newraison_refus_rendez-vous

        Null(), Autres

        ] ;

       

      AS_XX_XXX:

      ApplyMap('mapservicestatus2',[raison_refus_rendez-vous]) as [Newraison_refus_rendez-vous];

       

      And this is my expression:

       

      =Count({<Marquenew={'Citroën'}>}{<[Newraison_refus_rendez-vous]={'Rendez-vous déjà fixé','Véhicule vendu','Entretien déjà effectué','Autres'}>} [Newraison_refus_rendez-vous])

       

      Any idea where I am wrong?

       

      Many Thanks,

       

      Hasvine