0

monthly gl balances by dimension

Jet Reports Historic Posts

January 30, 2015 15:02

None

Follow

Hello

I am a beginner here in jet reports

someone please help me with enclosed file where monthly overheads figures are coming perfect , whenever i wanted to try changing formula to get the balances by dimensions gd1 or gd2 i could not succeed.

see the february salary cell the vale error.

please help with this issue

Warm regards

• Overheads by Month01.xlsx

• Facebook
• Twitter
• LinkedIn

7 comments

• 0
  
  Jet Reports Historic Posts January 30, 2015 15:32

  Hi,
  
  the Formular in the cell in Febuary (with the value-error) is different to the otherones.
  There are no brackets at "$H5+1"..
  Is that on purpose or maybe the error?
  
  regards
  jetsetter

• 0
  
  Jet Reports Historic Posts January 30, 2015 16:02

  Hello
  
  I did not put any brackets for other cells, when I check in the design mode also I can't find any bracket there yes but in the cells there is a bracket.
  
  Now I changed the same way for February cell also but still it does not work!!!
  
  Only when I try to get the gl balance with dimension then only this issue otherwise it's fine
  
  Warm regards
  
  Ravi

  • image.jpg
• 0
  
  Jet Reports Historic Posts January 30, 2015 23:01

  If you click on the cell with #VALUE, and choose Debug from the Jet Ribbon, what error message do you get? That may point at the culprit.

• 0
  
  Jet Reports Historic Posts January 31, 2015 00:10

  Thanks
  Problem solved , I just removed the view code , it seems gd1 gd2 by defaults can be used without selecting analysis view
  Code.. Wonder why it does not work with analysis view code, when that analysis view has the gd1 gd2 in the same order

• 0
  
  Jet Reports Historic Posts January 31, 2015 09:32

  hi, could you share your fixed report?

• 0
  
  Jet Reports Historic Posts February 01, 2015 06:23

  Here it is enclosed

  • Overheads by Month_v02.xlsx
• 0
  
  Jet Reports Historic Posts February 02, 2015 10:06

  thank you :)