Excel rounding and comparing to AX

I was working on something for a customer related to the contribution ratio in AX that I’ll cover in a later post. While I was working on that I decided I’d calculate the expected outcome in Excel to compare against AX. I was confused by the difference. This is not unusual in AX as rounding happens and there are parameter to control different aspects of it.

So I debugged AX and found that the calculation was in fact correct in AX so I went back to Excel and after some puzzling with different approaches for splitting up the calculation I came to the conclusion it was Excel rounding. I did some digging and after adding the ROUND() function I was matching what was in AX.

This link might help https://support.microsoft.com/en-us/kb/214118

Here is a quick overview.

Cheers

Lachlan

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s