cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CatPagulayan
Helper IV
Helper IV

Format a datacard to 2 decimal numbers

Hello,

So I have this DataCardValue which is a text input with the following details:

Default: (DataCardValue1.text*dropdown.selectedtext.value)/DataCardValue3.text

Format: number

So basically it calculates based from other fields.

I want the DataCardValue to have only 2 decimal places. How do I do it?

Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
Jagadeeshk
Responsive Resident
Responsive Resident

Try this,

Text(Value(DataCardValue1.text)*value(dropdown.selectedtext.value))/value(DataCardValue3.text),#.##)

View solution in original post

3 REPLIES 3
AmirBakht
Helper IV
Helper IV

Text(4/3, ".00")

This returns 1.33

 

Set the formula where you wish. If you are using it for display purposes only, put it on your text box.

 

Of course, 4/3 needs to be replaced by your calculation

Jagadeeshk
Responsive Resident
Responsive Resident

Try this,

Text(Value(DataCardValue1.text)*value(dropdown.selectedtext.value))/value(DataCardValue3.text),#.##)

View solution in original post

v-qiaqi-msft
Community Support
Community Support

Hi@CatPagulayan,

Based on the issue that you mentioned, do you want to format your DataCardValue with 2 decimal places?

Could you please share a bit more about your scenario?

I have a test on my side, please take a try as below.

Set the Default property of the TextInput  as below:

 

Text(
    DataCardValue8.Text * DataCardValue12.Selected.Value / DataCardValue11.Text,
    "[$-en-US]#.00"
)

 

090901.png

Best Regards,

Qi

Best Regards,
Qi

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (2,265)