• Michael Intravartolo

Quick Tip: Maximizing Speed with Calculations in Microsoft Dynamics NAV


You may not know that you can perform calculations in a numeric field inside of Microsoft Dynamics NAV. Doing the math inside the cells will save you time, rather than having to go to Microsoft Excel or using a calculator.

Note you are not able to use parentheses (), as Dynamics NAV only works with basic signs and decimals. If you need to do a more complex calculation, you will need to simplify the algebraic equation and then enter each one in steps in the cells, as shown below.

Examples of calculations Dynamics NAV can perform:

  • 2+2

  • Results = 4

  • 500.95-40.50

  • Results = 460.45

  • 5*2

  • Results = 10

  • 6/2

  • Results = 3

  • 10+30/2

  • Results = 25

  • Be careful with this one

Example of a calculation Dynamics NAV cannot perform:

  • (10+30)/2 = 20

How to enter complex equations into Dynamics NAV to receive the proper output:

  • Enter 10+30 into the cells, resulting in 40

  • Enter 40/2, resulting in 20

#microsoftdynamicsnav

0 views
Contact Us

Solution Systems, Inc.

3201 Tollview Dr. 

Rolling Meadows, IL 60008

Office: 847-590-3000

Email: info@solsyst.com

Support: 224-345-2020

Support Email: support@solsyst.com

Connect With Us
  • Manufacturing Software | Illinois
  • Manufacturing Software | Illinois
  • Manufacturing Software | Illinois
  • Manufacturing Software | Illinois
  • Manufacturing Software | Chicago
  • Manufacturing Software | Illinois
  • Microsoft Business Podcast
  • Manufacturing Software | Chicago
  • Manufacturing Software | Chicago
  • Manufacturing Software | Chicago
Join our Mailing List

© 2020 Solution Systems, Inc.