Forum Discussion
Solved
Format Extracted List To Show as Currency (Or Two Decimal Number)
Hi, How can i format the list that i extracted through List.Select to a currency format? See below M code and output. My desired result is for each of the value in row under...
If you want to have your list contain values with trailing decimals, as you show, you will need to convert the Number to a text string.
One way to do that is with List.Transform...Number.ToText which will both round the number and show it with two decimals.
List.Transform(decimalList, each Number.ToText(_,"0.00"))Original
Results
Have you tried wrapping the List.Select with List.Transform like:
each List.Transform(List.Select([All][Cost Per Unit], each _ > 0), Currency.Type)))
--Nate
Hi Nate,
I tried your recommended solution but it gives an error as below:
Thanks
Jojemar
