0

Opening Balance

Jet Reports Historic Posts

July 07, 2015 05:49

None

Follow

Hi Jet Community,

I am new to Jet Essential,

Please anyone can explain. how to calculate OpenBalance..

My formula Previous Value+Current Value


Thanks in Advance

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Jet Reports Historic Posts July 07, 2015 17:11

  Hi Nagaraju
  
  Typically there is an opening entry for various accounts so you could pull that record from the corresponding entry table.
  
  Not sure what type of opening balance you are looking to get.

• 0
  
  Jet Reports Historic Posts July 08, 2015 06:15

  Hi,
  
  Actually i have one field…
  Suppose Amount my field
  Amount
  100
  200
  300
  340
  12
  
  i want to calculate current value+ Previous Value means
  
  OutPut
  100 (100)
  300 (200+100)
  500 (300+200)
  640 (340+300)
  460 (12+340)
  
  Hope you understand

• 1
  
  Jet Reports Historic Posts July 15, 2015 23:24

  Hi nagaraju123,
  
  It is hard to say exactly how you should solve this problem as I don't really understand how your report is formatted or created. But, I think you are just trying to create a running total. I have attached a simple example of using Excel's Offset() function to sum the current line with the one above. I hope this helps!

  • NAV Running Total Using Offset.xlsx
• 0
  
  Estuardo E. León D June 13, 2018 16:19

  Hi everybody,

  To set a formula with running totals, like a progressive balance through the history on a report of a customer, the link to the file "NAV Running Total Using Offset.xlsx" that we need, thanks for this solution Jet Reports team.

  Best regards.

  Estuardo León.