0

Using a calculated field within a calculated field

Jet Reports Historic Posts

November 28, 2012 16:05

None

Follow

Hi,

Is it possible to use a calculated field within a calculated field?
I'm using Jet Essentials 2011.

This is my formula at the moment:
=NL("Rows","Sales Line",,"Task Date",StartDate&".."&EndDate,"=NL(""Count"",""Sales Line"",,""Quantity Base Line"",""True"",""Document No."",NF(,""Document No.""))",">0","=NF(,""Quantity"")+NF(,""Qty. to Dispose"")","<>0")

but I need to include the last calculated field "=NF(,""Quantity"")+NF(,""Qty. to Dispose"")" inside the first calculated field to be used as a filter. I've tried several different ways, but either didn't get the syntax right or it's not possible.

Many Thanks in advance

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Jet Reports Historic Posts November 28, 2012 16:50 Official comment

  Hi,
  
  Yes it should be possible. You just need quadruple quotes. Of course it's gonna be super slow, but it should work. I think it would look something like this:
  
  =NL("Rows","Sales Line",,"Task Date",StartDate&".."&EndDate,"=NL(""Count"",""Sales Line"",,""Quantity Base Line"",""True"",""Document No."",NF(,""Document No.""),""=NF(,""""Quantity"""")+NF(,""""Qty. to Dispose"""")"",""<>0"")",">0","=NF(,""Quantity"")+NF(,""Qty. to Dispose"")","<>0")
  Does that help?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts November 29, 2012 09:17

  Hi,
  
  That worked just fine.
  Also as you suspected it is quite slow, so will need to break the query down further to retrieve the data I need.
  
  Thanks so much for your help.