web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Comparisons in Analysi...

Small and medium business | Business Central, N...

Answered

Comparisons in Analysis Reports

(0) Share

Report

Report

Posted on by JE-29041340-0

392

Hi:

In Sales Analysis Reports, p[lease explain the date formula and period formula columns. I'm unclear on these.

Thanks!

John

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (2)

Verified answer

Valentin Castravet 31,452 Super User 2025 Season 2 on at

Like (1)

Report

Take a look at this website as it has a lot of examples. It's about Dynamics NAV Account Schedules (renamed to Financial Reporting in BC) but the concepts about Comparison Period Formulas and Comparison Date Formulas still apply to BC and to Sales Analysis Reports - Account Schedule Formulas | Dynamics NAV Financials

Was this reply helpful? Yes No
Verified answer

KasparsSemjonovs 4,770 Super User 2025 Season 2 on at

Like (2)

Report

Comparison period is used to see the amount in different period.
For example You want to do a trial balance for 12 months - then You do 12 columns, where on 1st the comparison is empty, and on all others you enter 1M, 2M, 3M, 4M....11M. Then when you run a report You must provide filter for January, and in 2nd column you will see +1M = February, and on 12th column You will see +11Months = December of the same year.

Similarly the comparison can be used to see Balance/Sales last Year = -1Y

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 2,577

#2

YUN ZHU 888 Super User 2025 Season 2

#3

Jainam M. Kothari 778 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans