0

Round before an NL sum?

Jet Reports Historic Posts

September 08, 2016 20:21

None

Follow

I need to do an NL sum function to total up quantities, but I want to round each quantity before summing. Is this possible?

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts September 09, 2016 15:19

  Hello -
  
  If you are using a Dynamics NAV data source, here is an example of how to incorporate Excel's ROUND function in an NL(Sum):
  
  =NL("Sum","Cust. Ledger Entry","=ROUND(NF(,""Amount""),0)")