2 Replies Latest reply: May 15, 2014 10:15 AM by psamson _ RSS

    memo type in summary

    psamson _

      I'm working on an extract from an excel database. I have to use the type field memo to get all the data from a field in excel. How do I can add this to my summary, memo type is not available in the pick list in the summary creation.

       

      Thanks for your help

        • memo type in summary
          Olly Bond

          Hello psamson,

           

          You can't, in a single model. There are two options - to export the summary as a database and then perform an external lookup in a second model from this export to pull in the memo fields, but then you're working from the table and don't have much control of formatting. The other approach is to chop up the memo field using calculated fields - maybe with TextLine() or Substr() - to create manageable Character type fields which can be items in your summary.

           

          Best wishes,

           

          Olly