0

Count number of entries in a year

Dear community,

I would like to count the number of entries in a sub table with the date being in a certain year.

count(select 'Verkauf' where year('Datum') = 2025) didn't work i.e.

Thanks for some ideas

2 replies

null
    • Ninox partner
    • RoSoft_Steven.1
    • 3 days ago
    • Reported - view

    This should work though except if the field 'Datum' is not a date-field

    • John_Halls
    • 3 days ago
    • Reported - view

    Hi  You are missing a second closing bracket

    count(select 'Verkauf' where year('Datum') = 2025))

    But if it's a subtable your code would count all the entries for every parent. I guess you are looking for a count per parent, in which case your code should look something like

    count(Verkauf[year(Datum)=2025])

    Where Verkauf is the reference field. The square brackets scope the entries down to just this year as the where clause is not available here.

    Regards John

Login to reply

Content aside

  • 3 days agoLast active
  • 2Replies
  • 24Views
  • 3 Following