Calculate between 2 tables


I have 2 table (one for cars and one for contact), in the car table i have column “type” and in the contact table I have column “car type”.
how can calculate the total contact with the same car type.


Hi @eilongold2503


  • Type (field type > text or option set display)
  • Car (field type > car)

This expression should do the trick > search contacts: count (with constraint “car = contacts’s car”)

This topic was automatically closed after 70 days. New replies are no longer allowed.