Problem counting instances

[pschweitzer]

Hi
I have a form that is parent and child of itself, and need to count how many previous entry there are with the same value on a question called pcode.

This formula counts how many entries there are previously and work fine
count(instance(‘ria_formb’)/root/data[pcode])

But this should count how many entries there are previously with same value in pcode and but it does not count and I cant understand why
count(instance(‘ria_formb’)/root/data[pcode=current()/…/pcode])

Any help?
Gracias
Pablo

[Kal_Lam]

@pschweitzer, have you gone through our support article that has all the workarounds you should need related to the dynamic data attachment?

New Support Article: Dynamic Data Attachments [Case Management]

Dear All, We are glad to inform you that with the recent release of new feature Dynamic Data Attachments (Case management) in KoBoToolbox, we have added a new support article Dynamic Data Attachments to our support page. [image] Please visit our Help Center Page to learn more about other support articles. [image]

[pschweitzer]

Hi @Kal_Lam yes thanks, I am pulling data between 6 forms but my problem is with counts and with once(count). This form collect a letter, and should: a) count how many letters were previously sent in total, b) count how many times the letter that is being sent now was sent, c) add 1 to the number calculated in ‘b’. Since the idea is that the value calculated in 'c ’ don’t change if the submission is edited, I put once() at the beginning.
But it do not work

Any help?
Thanks
conteos.xlsx (9,3 KB)