Forum Discussion

LarsAustin's avatar
LarsAustin
Helper I
4 years ago
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...
Need Help
  • ronrsnfld's avatar
    ronrsnfld
    4 years ago

    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

     

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I suppose the proper solution would involve List.TransformMany, but I've not yet used it. But you can probably wrap the whole List.Transform in another List.Transform, like

 

each List.Transform(List.Transform(List.Select([All][Cost Per Unit],  each _ > 0), Currency.From), Number.Round(_, 2)))

 

--Nate

 

 

  • LarsAustin's avatar
    LarsAustin
    Helper I
    4 years ago

    Hi Nate,

     

    I tried your suggestion above but it gives an error:

     

     

    I'm happy with the previous solution. Not being able to round to 2 decimals is not a biggie for my requirements for now. But i really appreciate you putting the time and effort to provide the desired outcome to my problem.

     

    Big thanks.

     

    Jojemar