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

    Embedded Formulas

    Deborah99C _

      Hi!  I have a question regarding formula-based calculated fields.  I currently have a model with this formula: Strip(,"-").  This gets rid of some unwanted trailing dashes that come up periodically in my report.  Now it has some unwanted 1's that I need to get rid of in order to summarize each item in this field into one line. 

      I've done embedded formulas before with the Monarch calculated fields, but for some reason I'm drawing a blank with this one.  Is there a way to embed another 'Strip' function in this formula to remove the 1's?  Or is there another function I should be using?  I would like to avoid creating another calculated field, if possible.

       

      Thanks a bunch,

       

      Deborah