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

    aggr and firstsortedvalue expression fails when fields changed to text

      Hi,

       

      I have a calculated dimension:

      =aggr(firstsortedvalue({<ContactType={'Email'}>}ContactDetail,-ContactID),TR_ID)

       

      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.