4 Replies Latest reply: May 27, 2017 3:43 PM by Koen Bal RSS

    Adhoc Reporting

    ben lim

      Hi all, I am currently doing an adhoc Interface for QV user to retrieve data on the table.

       

      I have a list of selection fields where when user click, the specific dimension/expression will show on the table.

       

      However, on my expression, I have TEU and Transit_TEU

       

      Using Calculated Condition, I tried using

      =SubStringCount(Concat(_Dimension, '|'), 'Transit_TEU')

       

      as well as

       

      =SubStringCount( Concat(DISTINCT _Dimension) ,'Transit_TEU')

       

      It appears Transit_TEU and TEU which is not the output that I am looking for

       

      any advise for this