How do I consolidate data from GL?

user06690
user06690 Member
in Charting

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 Contributor
    Answer ✓

    BEAST MODE example

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

    1234567890123456 -> 1234567890

Answers

  • Tomo
    Tomo Contributor
    Answer ✓

    BEAST MODE example

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

    1234567890123456 -> 1234567890

This discussion has been closed.

Categories