0

Excel formula in NL(Table [RESOLVED]

Jet Reports Historic Posts

November 24, 2011 14:51

None

Follow

Is it Possible to create a NL(table function with a field which is a Excel Formula?

for example I would like a table with three fields from a Nav database:

Job NO.
Job Description
Amount

The Fourth field I would like for example an Excel formula like If(amount>10;"Good";IF(amount>20;"Really Good"; "");"")

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Jet Reports Historic Posts November 24, 2011 15:35

  Hi,
  As far as I tested the Table Builder functionality for JetExpress it's not possible to add calculated columns within a table - this feature is available with JetEssentials.
  
  Elena

• 0
  
  Jet Reports Historic Posts November 29, 2011 19:44

  You can click the [size=150]+[/size]Add Formula link (between Fields and Flow Fields) to add your formula.
  
  I would recommend using the latest version of Express available from the Express Resource Center (http://jetexpress.jetreports.com/index.php)
  
  Your function would end up looking something like this:
  
  =NP("Formula","=IF([[#This Row],[Amount]]>20,""Really Good"",IF([[#This Row],[Amount]]>10,""Good"",""""))")
  
  -HP
  

• 0
  
  Jet Reports Historic Posts November 30, 2011 07:17

  Unfortunately that functionallity isn't available in the express version as far as I can see.
  
  It tells me that the formula function is available from the jet Essentials Version.

• 0
  
  Jet Reports Historic Posts November 30, 2011 16:17

  My apologies…
  
  You are absolutely correct!
  
  -HP