0

Multiple G/L Accounts not in range

Jet Reports Historic Posts

December 16, 2015 17:37

None

Follow

Dear Community,

I have an issue for which I need your help.

In our G/L I need to sum multiple accounts, however, they are not sequential. e.g. I need to sum account 1,5,8,11,13,16 (but excluding 2,3,4,6,7,9,10,12,14,15) in the GL function. Are there any smart way to do this?

All the best,

Frederik

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts December 16, 2015 17:54

  Hello Frederik,
  
  You should be able to use "|" between your accounts in your function.
  You can only use posting accounts though, if you include a totaling account it will be excluded from the end result.
  e.g.
  =GL("Balance","1|5|8|11|13|16",,"12/31/2015")
  You could also list them out individually and then use an Excel SUM() function to add them together.
  e.g.
  D3: =GL("Balance","1",,"12/31/2015")
  D4: =GL("Balance","5",,"12/31/2015")
  D5: =GL("Balance","8",,"12/31/2015")
  D6: =GL("Balance","11",,"12/31/2015")
  D7: =GL("Balance","13",,"12/31/2015")
  D8: =GL("Balance","16",,"12/31/2015")
  D9: =SUM(D3:D8)
  
  Take a look at the attached screenshot for an example.
  
  Best regards,
  MWilson
  
  

• 0
  
  Sandeep Kuntam January 15, 2020 21:56

  Hello, 

   

  I have a unique problem and will need to see if anyone here can point me to a solution. 

  I need to have balance on multiple GL accounts in one line which are not exactly in a range but are in a smaller range of their own. 

  for example from Fabrikam company I would need to get balance of these GL's in one line. notice I will need to use wildcards and ranges. 

  000-1300-01|0001300-02|000-1330-*|000-1350-02..08