0

Counting a specific set of subrecords in each recordHello, I have simple question. I build a to-do app and I want to count all the accomplished items in for each special project. I made a formula field with this syntax: cnt(select Tasks where Status like "Accomplished"). But now it counts all the tasks in every project. Is there a way to count only the tasks in a specific projects. Thanks for answering Hans

Hello, I have simple question. I build a to-do app and I want to count all the accomplished items in for each special project. I made a formula field with this syntax: cnt(select Tasks where Status like "Accomplished"). But now it counts all the tasks in every project. Is there a way to count only the tasks in a specific projects. Thanks for answering Hans

2 replies

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

    Hans,

    This should work:

    let me := this;
    cnt(select Tasks where Project = me and Status like "Accomplished")

    Steven

    • Hans_van_den_Herik
    • 3 yrs ago
    • Reported - view

    Thanks a lot. It works perfectly!

Login to reply

Content aside

  • 3 yrs agoLast active
  • 2Replies
  • 823Views