0

Changing Negative numbers to Positives

Jet Reports Historic Posts

April 23, 2008 18:42

None

Follow

Navision reports a sale of an item as a negative number (-1). What can I add to my Jet Report formula to return negative numbers as positive numbers?
Thanks!

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts April 23, 2008 20:15

  airplaneguy,
  
  You can always just multiply the number returned by -1.
  
  Some examples,
  
  =NF(CellRef,"Amount")*-1
  =NL("First","G/L Account","Balance")*-1
  
  or to always have a positive number no matter if the number from the database is neg or pos, you can use
  
  =ABS(NF(CellRef,"Amount"))