2 Replies Latest reply: Mar 29, 2011 7:15 AM by Deepak Vadithala RSS

    Space (Character) problem in Set Analysis

    Deepak Vadithala

      Dear All,

      I have an expression which works for all the dimensions expect one of them. The one which does not work have a space between two words like (example : Hard Coder). And rest all of them are single words and they work perfect! Please help me to solve this problem...

       

      =Sum({1<Year={$(=($(vMaxYear)))}, MonthNumber={$(=($(vCurrentMonthNumber)))}, Usertype = {$(=(Usertype))}>} Sales)

      Usertype : This is the field name which contains - Hard Coder.

       

      I hope this makes sense. I am sure this must be simple but I can't get my head around this one...

      TIA!

      Cheers - DV