web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How to get the formula...
Small and medium business | Business Central, N...
Suggested Answer

How to get the formula for Cost percentage per region

(2) ShareShare
ReportReport
Posted on by CU20112316-1 211
Can we create a formula where we can check the cost percentage per region and comparing it through the consolidated region or subsidiaries.
 
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Assisted by AI
    OussamaSabbouh Profile Picture
    OussamaSabbouh 7,836 on at
    Hello,
     
    Yes, this can be done cleanly using Account Schedules by adding formula columns that calculate each region’s cost as a percentage of the Consolidation (total) column. In the Column Layout, keep your existing amount columns, then add new columns with Column Type = Formula and formulas like US / Consolidation * 100, Ireland / Consolidation * 100, etc. When used on the Total Cost row, this shows each region’s share of the consolidated cost and lets you easily compare subsidiaries against the group, as long as the consolidation column represents the true total.
     
    Regards,
    Oussama Sabbouh
  • Suggested answer
    Dhiren Nagar Profile Picture
    Dhiren Nagar 959 on at
     
    As far as Business Central view is concerned, I tried thinking of applying various formulas but it won't work. You can create column through for each region's % to consolidated amount. But that will be too many columns.
     
    Another and I guess better alternative is utilizing Excel Layout feature of Financial report where if you export this report in excel you can get this row created in excel with easy excel formula and you will get the data. However that row will not be visible in Business Central Financial Report view.
     
    Here is link to the feature - https://www.youtube.com/watch?v=0fzwIwCladI&t=6s (Check the excel layout feature).
     
    Regards,
    Dhiren.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,476

#2
Khushbu Rajvi. Profile Picture

Khushbu Rajvi. 789 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 719 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans