These are the same values but with different representation. If you want to display data with “your” format then you need to format it properly. The simples way to achieve that is to use :io_lib.format/2 function:

<%= for card <- @cards do %>
$<%= :io_lib.format("~.2f", [card.card_income]) %>
<% end %>

Alternatively you can use ExCLDR.Numbers library that will allow you to format data with proper locale.

Thanks, it works but one issue how to handle if the value is nil giving an error instead of showing blank.

44%20PM698×448 14.9 KB

I think there are a couple of things to think about:

1. It looks like you’re dealing with money. Its not a good idea to use floats to represent money. There are lots of well-known issues. It would be much better to use decimals. There are a few money libraries around that can help.
2. If indeed you are working with money then I think you should consider nil an invalid value. The balance is 0 or some other value. I think io_lib.format/2 is doing the right thing.

After changing the data type from float to decimal and default value to zero instead of null when I run the website in browser it shows error as shown below in the screenshot. NOTE: If I am not formatting my number using io_lib.format/2 the page shows correct data what I expect but now it is not accepting formating why ?

15%20PM711×447 16.3 KB

:io_lib.format/2 works only with basic types, it has no knowledge how to format Elixir structures, especially when you want to format map as a float. However as you store them as decimals then you do not need formatting at all and plain card.card_income should work.

I feel summoned… ^.^

Never ever ever ever represent money as floats, never ever ever ever EVER.

There are some good money libraries for elixir that will handle money properly, just never ever ever ever store money as a float.

Now as for this issue, even changing it to decimal is still not ‘quite’ right as you lose information about the value, like what type it is and thus how it should be formatted.

If this is indeed money, use a money library, it will format it properly and all.