0

Formula in table builder

Jet Reports Historic Posts

August 28, 2015 09:08

None

Follow

Hi

I have a problem with formula in table builder.
Here my formula (using concatenate):
=NP("Formel";"=sammenkædning([@[Item No.]];""-"";[@[Item - Description]]")

In the finished table an apostrophe is added:
'=sammenkædning([@[Item No.]];"-";[@[Item - Description]]
If I remove the apostrophe it changes to the correct result.
Cell if formatted as standard.
I read in another post that changing formula from ";" to "," as separator could help,
but unfortunately this does not help.
I am using latest Jet Essentials 2015 Update 1. and excel 2013.

Does anyone know the solution to my problem ?

Br. mdp12

• Facebook
• Twitter
• LinkedIn

3 comments

• 
  Jet Reports Historic Posts October 27, 2016 18:32 Official comment

  :lol: :lol:
  
  figured it out. I was typing in "=formula" in the table builder. Took that out and it works fine. Thanks for all of your help!

• 0
  
  Jet Reports Historic Posts September 01, 2015 15:48

  Hi Mdp
  
  You are missing a parenthesis at the end of your Concatenate statement before the final "
  
  =NP("Formel";"=sammenkædning([@[Item No.]];""-"";[@[Item - Description]])")

• 0
  
  Jet Reports Historic Posts September 02, 2015 20:55

  Hi JET-btr
  
  I did include parenthesis in my original formula, but I
  see know I forgot to add uselocalformulas=true to my table function. :oops:
  
  Thanks for your help
  mdp12