0

Adding range of account [SOLVED]

Jet Reports Historic Posts

November 22, 2016 15:39

None

Follow

Hi, I'm pretty new with the Product. I would like to know how could I enter on a line for example account 000-1000-00 through 000-1500-00 minus account 000-1200-00? Is there a way to do this efficiently with Jet Express for Excel with GP?

Thanks
Pat

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts November 22, 2016 16:34

  Hi Pat -
  
  I am assuming you are after a balance for those accounts.
  
  Try this:
  
  =GL("Cell","Balance","000-1000-00..000-1500-00")-GL("Cell","Balance","000-1200-00")
  -HP

• 0
  
  Jet Reports Historic Posts November 22, 2016 16:59

  Thank you very much!