cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Microsoft
Microsoft

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
Highlighted
Dual Super User II
Dual Super User II

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.

View solution in original post

1 REPLY 1
Highlighted
Dual Super User II
Dual Super User II

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.

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,405)