1 Reply Latest reply: May 15, 2014 9:55 AM by Grant Perkins RSS

    Fields

    Oscar _

      I was wondering if there was anyway I could duplicate a field.  I have to export the data to excel where there are is a field for customer name and for payor. Both fields are usually the same.  After I export the data from monarch to excel I usually have to copy the customer name field and relabel it "Payor".

        • Fields
          Grant Perkins

          Oscar,

           

          If your report has no Payor information and it is safe enough for you to make the assumption that the same name will be OK, simply create a new calculated field and make the 'formula' the name of the field you want to copy.

           

          That's it.

           

          On the other hand if you want to do that only when another field is not populated you would likely require another IF() based formula. But from what you wrote it sounds like there is no other data around to use so just copy the field.

           

          HTH.

           

           

          Grant

           

          [size="1"][ August 18, 2006, 06:04 AM: Message edited by: Grant Perkins ][/size]