3 Replies Latest reply: Jun 6, 2017 9:42 AM by Sunny Talwar RSS

    Equality in 'If' statement

    Justin Dallas

      Hello Everyone,

       

      I have a straight table with a field named  'exp_id'.    In my data model, I also have two other fields, StatusStartDate, StatusEndDate, and CalDate.  In the straight table, I have this


      Expression_!.PNG

       

      But when I go to my straight table, I am greeted with this "Invalid Dimension" error.

       

      Expression_2.PNG

       

      What concept am I missing here?  What I am trying to say is

       

      "Only show the exp_id property if the StatusStartDate comes before the smallest selected CalDate"


      Any help is greatly appreciated.