You’re offline. This is a read only version of the page.
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.
Any ideas?
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/
Share
Report
All responses (
Answers (
69,226
