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

Comments

1 comment

  • Official comment
    Avatar
    Kristin Town

    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. 

Please sign in to leave a comment.