News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... calculation on percent...

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

Suggested answer

calculation on percentage.

(0) Share

Report

Report

Posted on by Austin360

30

Hello Professionals.

I kindly need your assistance to make a calculation in percentage value of a figure.

Example : I want to be able to do (calculate) in DAX

19.25% of 128901578.82 = < Answer >

Kindly note from the above, both 19.25% and 128901578.82 are already defined on a different column.

Best regards.

All responses Img

All responses (4)

Answers Img

Answers (0)

Suggested answer

Nitin Verma 21,324 Moderator on at

Like (0)

Report

RE: calculation on percentage.

You can try below

Name DataType Subtype Length
DecValue Decimal
DecValue2 Decimal
documenttext Text

documenttext := '19.25%';

IF STRPOS(documenttext,'%') > 0 then

BEGIN

documenttext := DELCHR(documenttext,'=','%');

EVALUATE(DecValue,documenttext);

DecValue2 := 128901578.82;

DecValue := (DecValue2 * DecValue) /100;

END;
Austin360 30 on at

Like (0)

Report

RE: calculation on percentage.

oh ! sorry , they are defined as figures (123).
Austin360 30 on at

Like (0)

Report

RE: calculation on percentage.

No , hardcoded .

figures (123)

Best regards
Suggested answer

Nitin Verma 21,324 Moderator on at

Like (0)

Report

RE: calculation on percentage.

Hi,

Is 19.25% defined as text value?

Thanks.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2

Martin Dráb 231,432 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans