AnsweredAssumed Answered

How can I count related data with a special parameter?

Question asked by disabled_Luna.media on Apr 6, 2017
Latest reply on Apr 6, 2017 by taylorsharpe

Hi,

I have a quite simple database with companies, contacts and materials per contact. Now I want to show the number of a special types of materials in a list of companies for each company. Among materials we have "photo" or "document". Each material recordset has a field "type".

 

I tried something like a sum together with an if-clause but it always counts all related material recordset if at least one of it had the right type or nothing.

 

Any ideas?

Luna

Outcomes