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

H

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

Ninox Profile

Hans,

This should work:

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

Steven

H

Thanks a lot. It works perfectly!

Reply