AVG

2 posts, 0 answers
  1. Rubens
    Rubens avatar
    1 posts
    Member since:
    Oct 2013

    Posted 14 Oct Link to this post


    I have a report that shows the date, I want to take an average, but when using Avg (date) error
    I have a report that shows the date, I want to take an average, but when using Avg (date) error
  2. Peter
    Admin
    Peter avatar
    1611 posts

    Posted 19 Oct Link to this post

    Hi Rubens,

    The Avg aggregate works only with number types. If you want to use it with a date type. Consider converting the date to int for use in the aggregate and then back date from the aggregate result. Another option is to create your own aggregate as elaborated in  User Aggregate Functions help article.

    Regards,
    Peter
    Telerik by Progress
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. DevCraft banner
Back to Top