2 Replies Latest reply on Aug 2, 2018 10:29 AM by jon rios

    if statement question

    jon rios

      based on my assumptions of Tableau calc, i assume that this column in red should all be True, correct?  if not, why not. and so what exression would make this True?

        • 1. Re: if statement question
          Naveen B

          Hi Jon,

           

          Try trim(segmentlabel1)="Now 2 CPD" may be due to trailing spaces it may causing the issue

           

          Try and let me know or lets is it possible to attach workbook with fake data so that it will be easy to help

           

          Kindly mark this answer as correct/helpful to close the thread

           

           

           

          BR,

          NB

          • 2. Re: if statement question
            jon rios

            hi Naveen

             

            i tried but still get False. i created a Trim([SegmentLabel1]), which should return the labels name but trimmed, correct?

             

            it returns an #Error  but i cant dig deeper to what it is... any toughts? does this 'remote type' have any issues?  BTW, the data is coming from an Extract on tabl Server