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... General Ledger (negati...

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

Suggested Answer

General Ledger (negative numbers as sales)

(0) Share

Report

Report

Posted on by Community Member

Hello.

The General Ledger table shows negative numbers for SALES. In Power Bi desktop, this table shows a SALES number in negative.

How do you automatically show the numbers in Power Bi as positive, considering that these number will have to be refreshed regularly?

Thanks.

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

JAngle 133 on at

Like (0)

Report

Just add a new column and calculate it. New column might be called SALES = abs(sales value)

Salesvalue is the data field from BC in my example.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Josh,

What do you mean by "Salesvalue is the data field from BC in my example."?

Thanks.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

OussamaSabbouh 3,143

#2

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans