Reporting: How can I get just the student's middle initial in my custom report?

Follow

Kristin Town

March 24, 2017 20:38

The only field that is available is for names is Middle Name or a combination field that includes student's first, middle, and last name in one column. How can I get JUST the middle initial?

0

• Official comment

  

  Kristin Town March 24, 2017 20:47

  Under the advanced tab in your custom report, you will see Add a Calculation. We now support concatenation and substring calculations. In this instance, you will create a calculation using the substring functionality.

  

   

  In my example, the column for Middle Name is column D. I only want the first value in the column since I just want the first letter of the middle name to appear. Therefore, my substring will be as follows:

  SUBSTRING(D FROM 1 FOR 1)

  Please note that you will need to uncheck the box for Treat Blank Values as Zero? as that will break the calculation. 

  I also named the calculation Middle Initial and hid the Middle Name column to avoid confusion. 

  For more advanced assistance with building your custom report, check out our Custom Report section in our help documents. 

  Comment actions Permalink

Please sign in to leave a comment.