cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
russrimm
Level: Powered On

Decimal places and Currency

Hi all,

I am struggling to get two decimal places to show in my datatable.  I stuck a label in over to the right that has Text(Sum(expense,Estimated),"[$-en-US]#,##0.00") and notice that it shows $12.50 which is how I want it to display.  However, in the datatable under "Estimated Expense", it shows $12.5 instead of $12.50.  I tried setting the Items value of the datatable to AddColumns(expense,"calcfield",Text(EstimatedDatacard.Text,"[$-en-US]#,##0.00")) but I must have it wrong as the added column is completely empty. 

"EstimatedDatacard" is the inputbox under "Estimated Expense" which is set to a "Number" format.

Decimal.PNG

Any ideas?

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Decimal places and Currency

Right now there is no way to apply formatting directly to a data table column.  But you can use AddColumns to add pre-formatted fields to the datasource or collection you are passing to a data table.  Here's a Blog that shows how to do it.

https://blogs.msdn.microsoft.com/carlosfigueira/2017/09/01/formatting-fields-in-data-tables/



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
1 REPLY 1
Super User
Super User

Re: Decimal places and Currency

Right now there is no way to apply formatting directly to a data table column.  But you can use AddColumns to add pre-formatted fields to the datasource or collection you are passing to a data table.  Here's a Blog that shows how to do it.

https://blogs.msdn.microsoft.com/carlosfigueira/2017/09/01/formatting-fields-in-data-tables/



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 51 members 4,856 guests
Please welcome our newest community members: