I have an App that is linked to our GL and I am trying to create a field that rolls these GLs up into the line totals people are used to seeing.
For example, say GL account numbers 900000 and 910000 are both included in our Gasoline Sales P&L Line, and 905000 and 915000 are both included in our Diesel Sales P&L Line, I have rolled these up so that they are included in a new field I named P&L Line. See below:
If(Match([AccountNum],'900000','910000'),'01. Gas Gallons',
If(Match([AccountNum],'905000','915000'),'04. Diesel Gallons','Other')) AS 'P&L Line'
These are all working as expected, but my issue is that I also want to have a third 'P&L Line' that totals these two as 'Total Gallons' and haven't figured out how I can have all three.