removing decimal places from text boxes

(1) Share

Report

Posted on by Channah

205

Hi,

I am trying to remove the decimal places on the output of a calculation for a text box.

(DataCardValue137.Selected.Value + DataCardValue138.Selected.Value + DataCardValue139.Selected.Value) / 15 * 100

attempted round down function but having issues to make it work.

Can anyone help?

thanks!

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Vijay Tailor 2,961 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Please find below the URL. I hope it will help you to resolve your issue.

you can use like below expression -
int(DataCardValue137.Selected.Value + DataCardValue138.Selected.Value + DataCardValue139.Selected.Value) / 15 * 100)

for More Details check the below-mentioned thread.

https://powerusers.microsoft.com/t5/Building-Flows/Removing-decimal-points-on-calculated-column/td-p/189802

Thanks,
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

You can also try:
Text(Value(DataCardValue137.Selected.Value + DataCardValue138.Selected.Value + DataCardValue139.Selected.Value) / 15 * 100),"[$-fr-FR]# ###","fr-FR")

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Channah ,

Could you please show more details about the issue that you mentioned?

Do you want to remove the decimal places from the Calculation result?

Based on the needs that you mentioned, I think the Round function could achieve your needs. Please consider set the Default property of the Text Input Box to following:

Round( (DataCardValue137.Selected.Value + DataCardValue138.Selected.Value + DataCardValue139.Selected.Value) / 15 * 100, 0 )

Note: The Round function is required to provide two arguments value. Please check the following article for more details:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-round#syntax

If you want to remain two decimals within the Text Input box for your calculation result, please modify above formula as below:

Round( (DataCardValue137.Selected.Value + DataCardValue138.Selected.Value + DataCardValue139.Selected.Value) / 15 * 100, 2 )

Please take a try with above solution, check if the issue is solved.

Best regards,
Michal Z. 149 on at

Like
a
(0)

Report
Copy link

Link copied!
@VijayTailor There is no int function in PowerApps.
You can use mod instead.
If you have a value with decimals and want to get the integer value, use the following:

Value-Mod(Value,1)