News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... what is the formula fo...

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

Suggested answer

what is the formula for showing data for a quarter?

(1) Share

Report

Report

Posted on by CU29101917-0

76

I want to add the column defnition, Q1, Q2 for my rows. However, it's not giving me any values for these columns.

For e.g. row is 'Revenue' but columns Q1 and Q2 are blank.

What formula I should be entering for Q1 and Q2 so it gives me revenue by quarter for column Q1 and Q2?

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

Khushbu Rajvi. 17,377 Super User 2025 Season 1 on at

Like (1)

Report

what is the formula for showing data for a quarter?

it will help; https://www.youtube.com/watch?v=hFSrDHFrBU8
Suggested answer

YUN ZHU 84,467 Super User 2025 Season 1 on at

Like (1)

Report

what is the formula for showing data for a quarter?

Hi, hope the following helps as well.

Comparing accounting periods using period formulas: https://learn.microsoft.com/en-us/dynamics365/business-central/bi-column-definitions?wt.mc_id=DX-MVP-5004336#comparing-accounting-periods-using-period-formulas

Thanks.

ZHU
Suggested answer

Valentin Castravet 28,272 Super User 2025 Season 1 on at

Like (0)

Report

what is the formula for showing data for a quarter?

Duplicate of this thread....Business central not showing data by quarter (dynamics.com)

Helpful resources

News and Announcements

Check out the New Agent Creator Community

Announcing new navigation menus and the Engage with the Community forum!

Quick Links

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

#1

Sohail Ahmed 1,452

#2

YUN ZHU 1,313 Super User 2025 Season 1

#3

Gerardo Rentería Ga... 1,083 Most Valuable Professional

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans