0

Sort by NF * NF Calculation

Jet Reports Historic Posts

July 29, 2009 01:51

None

Follow

Hi,

i have a Formula that calculates a value from two other values using NF's
Something along the lines of "=NF(,""Unit Cost"")*NF(,""Quantity (Base)"")"

is it possible to sort by this???

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts July 29, 2009 09:00

  Jet Reports provides a nice sample report that shows how to sort by a Sum. I would like to suggest to you take a closer look at that report first: http://community.jetreports.com/viewtopic.php?f=13&t=67

• 0
  
  Jet Reports Historic Posts July 29, 2009 09:09

  Ofcourse if you still have trouble after reading the article you can also do:
  
  =NL("Rows";TABLE;;"+=Local(NF(,""Unit Cost"")*NF(,""Quantity (Base)""))";"*")
  
  

  Jet Reports provides a nice sample report that shows how to sort by a Sum. I would like to suggest to you take a closer look at that report first: http://community.jetreports.com/viewtopic.php?f=13&t=67

  
  BTW: this sample report does not work in a NON-US Excel. Problems with the date filter and the IF and TODAY functions.