0 Replies Latest reply: Sep 14, 2011 9:56 AM by Catherine Ball RSS

    aggr and firstsortedvalue expression fails when fields changed to text



      I have a calculated dimension:



      This was working ok until the format of the ContactID and TR_ID fields changed from numeric (e.g. 95423) to text (e.g. ABC95423).


      The dimension is used in a straight table chart and has changed from returning the email address field to being unable to return anything, just a - in the field.

      Can anyone help?
      Thanks, Catherine.