Rounding to 2 decimal digits i

(0) Share

Report

Posted on by muaz deyab

I want to get the amount with vat with two decimal digits but without rounding for example if i have 8521.0055 i want to get 8521.00

I did some search and found that I can use format for that but it keeps giving me error.

Can someone help me with that

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

Hi muaz deyab ,

Please try below rounding function.

ROUND(8521.0055,0.1)

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

Also please try below

FORMAT(ROUND(8521.0055,0.1),0,'<Precision,2><sign><Integer Thousand><Decimals,3>')

Thanks.

Was this reply helpful? Yes No
muaz deyab 90 on at

Like (0)

Report

this will return a text right?

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

Yes it will return as a text

Was this reply helpful? Yes No
muaz deyab 90 on at

Like (0)

Report

Thanks for ur answer it really helped me but when i enter 8521.3160 it gives me 8521.32 i want to get the exact same two decimal digits (8521.31).

So I converted the Total Amount to text then deleted everything after two decimal digits

TxtAmount := Format(TotalAmount);

POS := StrPos(TxtAmount, '.');

Evaluate(AmountWithVAT, TxtAmount.Remove((POS + 3)));

this is the code

and thank you for your answer again

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

Hi muaz deyab ,

As per the code I sent it will always round the values by seeking its decimal places, means it will increase or decrease accordingly, but as you said you want exact same 2 decimal values, in that case you have to use below logic

TextVal := FORMAT(8521.3160);

IF STRPOS(TextVal ,'.') > 0 then

TextVal := COPYSTR(TextVal,1,STRPOS(TextVal,'.')) + COPYSTR(TextVal,STRPOS(TextVal,'.')+1,2);

Was this reply helpful? Yes No

Join the conversation

Community site session details

Rounding to 2 decimal digits i

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

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

Featured topics

Product updates

Community site session details

Rounding to 2 decimal digits i

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates