grangerelixx
I am trying to get the float value of the following field:
Post
|> select_merge([p], %{post_length_avg: type(p.sum_of_post_words / p.total_posts, :float)})
|> Repo.all()
Lets say,
sum_of_post_words = 424 and total_posts = 1256
post_length_avg = 424/1256 = 0.3375796178343949
But the query returns post_length_avg = 0.0
How to get the full value 0.3375796178343949 ?
Any suggestions are appreciated.
I also came across Decimal but not sure how to use it in this case.
Where Next?
Trending in Questions
Other Trending Topics
Latest Phoenix Threads
Latest on Elixir Forum
Sponsor Spotlight
Supporting innovation across the BEAM ecosystem.
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #deployment
- #library
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #channels
- #elixirconf
- #exunit
- #discussion
- #code-sync
- #javascript
- #podcasts
- #onsite
- #dialyzer
- #docker
- #authentication
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #ecto-query
- #elixir-ls
- #blog-post
- #phoenix_html
- #iex
- #graphql
- #ai
- #genstage
- #elixirconf-us
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #api
- #forms
- #metaprogramming
- #security
- #hex
Our Sponsors
Build Elixir applications with speed and confidence.
Supporting innovation across the BEAM ecosystem.
We build reliable cloud platforms for business-critical systems.
Catch errors, track performance, monitor hosts and more.
Error tracking, logs, uptime, and Just Enough APM. Built for developers.
Practical resources that improve the lives of professional developers.
Develop your skills with books, videos, and courses.
Enabling companies to succeed by building software people love.
The team behind Membrane, Popcorn, LiveDebugger. Available for hire.
Courses that'll move you from confusion to "Aha, now I get it!"
First Post!
kip
Postgres, like Elixir, has both floating point division and integer division. In the example you show, you are asking Postgres to do integer division because both operands are integers. And the result of
424 / 1256will therefore be0and casting0to float will be, as you saw,0.0.Therefore you’ll need to cast the columns
sum_of_post_wordsandtotal_postsinto floats before the division.Something like (not tested):