How do I consolidate data from GL?

I am trying to summarize data based on a database table that contains thousands of GL entries. The problem I am trying to solve it summarizing the data based on part of the GL.

 

For example: I have a GL that is 16 numbers long and I want to summarize data based on numbers 1-10. Is this possible? So any record with a GL value of 1234567890xxxxxx should sum together as a single value.

Best Answer

  • Tomo
    Tomo 🟢
    Accepted Answer

    BEAST MODE example

    left(concat(1234567890123456,''),10)

    1234567890123456 -> 1234567890

This discussion has been closed.