0

Table builder NP formula() does not execute

Jet Reports Historic Posts

December 16, 2014 08:31

None

Follow

Hi all,

I already checked the KB for relating questions, but none of the topics did solve my problem.
My report is built using table builder and I want to insert this calculated column: =NP("Formula";"=if ([@[Postenart]] = ""Abgang"";-[@[Differenzwert]]; [@[Differenzwert]])")

The result is, that Excel interprets it as text, puts an apostrophe in front of it and so all I get is the formula string in the resulting table. What might be the reason?

Thanks very much in advance and kind regards,
Maja

• Facebook
• Twitter
• LinkedIn

4 comments

• 0
  
  Jet Reports Historic Posts December 17, 2014 13:42

  Hi,
  
  Try this formula:
  =NP("Formula","IF( [@[Postenart]]=""Abgang"",-[@[Differenzwert]],[@[Differenzwert]])")
  
  In case your modifying the formula by retrieving your XML template in table builder, then you can try the following:
  IF( [@[Postenart]]="Abgang",-[@[Differenzwert]],[@[Differenzwert]])
  
  In case it does not work, kindly share the excel sheet/xml format for further help.
  
  -Neeraj Rajpal

• 0
  
  Jet Reports Historic Posts December 17, 2014 13:55

  For your reference, I can execute a report with following formulas seamlessly:
  
  Source Table: Customer:
  
  =NP("Formula","IF( [@[Balance (LCY)]] =0,""Zero"",""Not Zero"")")
  
  =NP("Formula","IF( [@[Name]]=""New Concepts Furniture"",""Match"",""Not Matching"")")

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

  I experience the same issue if I use TableBuilder in Excel 2013 to develop a report and Excel 2007 to run the report.
  
  Excel 2013 TableBuilder column reference = @[column_name]
  Excel 2007 TableBuilder column reference = #[[This Row],[column_name]]
  
  Hope this isn't too late.

• 0
  
  Jet Reports Historic Posts January 12, 2015 15:50

  I've come across this issue before when running reports in Excel 2007. I believe the solution at the time was to update at the most recent version of Jet