How to totaling Dimension Values.

(7) Share

Report

Posted on by CU08052056-0

1,185

Hi experts!

I would like to use Diminution Value in order to total other Dimension Values such like "ACCOUNTALL Totaling = 101 + 102", but does not works.
If removing the half-width space as in 'ACCOUNTALL Totaling = 101+102' does not work either." Can I totaling that?

Look forward to hearing form you.
Nobuhara

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

DAnny3211 11,397 on at

Like (3)

Report
Hi Nobuhara 👋

Thanks for your question!

To total Dimension Values in Business Central, the syntax in the Totaling field must follow specific formatting rules. If you're trying to create a value like ACCOUNTALL that totals 101 and 102, here’s what you can try:

✅ Correct syntax for totaling:

Use commas to separate values:
101,102

Avoid using + signs or spaces—these are not valid in the Totaling field.

✅ Steps to apply:

Go to the Dimension Value setup page.

Create a new Dimension Value (e.g., ACCOUNTALL).

In the Totaling field, enter:
101,102

Save and test the setup in your reports or filters.

This should allow ACCOUNTALL to represent the sum of values 101 and 102.

Hope this helps!
✅ Please mark this reply as helpful if it answered your question.
Best regards! 👋

Was this reply helpful? Yes No
Suggested answer

Sumit Singh 10,079 on at

Like (2)

Report

I think you should use commas to separate individual dimension values.

Please check I think, total dimension values 101 and 102, you should write like below:-
101,102 instead of 101+102

References
[1] Work with dimensions to track and analyze data - Business Central

Mark the Answer as Verified if this is Helpful.

Was this reply helpful? Yes No
Verified answer

YUN ZHU 95,331 Super User 2025 Season 2 on at

Like (4)

Report

Hi, This is for you to enter a range of values, not a formula.

For example, You can enter 101..102, or 101|102

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (3)

Report

Please check the below example, you need to set Begin Total and End-totals and use the range

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,136 Super User 2025 Season 2 on at

Like (2)

Report
You can’t use formulas like 101+102 in dimension value totaling. Instead, you need to enter them as a range or list.

For example:

Use 101..102 to cover a continuous range.

Use 101|102 to pick specific values.

✅ Mark this as the verified answer if helpful.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,275 Super User 2025 Season 2 on at

Like (2)

Report

Just adding for more details: https://community.dynamics.com/blogs/post/?postid=727343f7-ce86-4e38-a75b-43f647f1130a

Was this reply helpful? Yes No