Calculate between 2 tables

Hey,

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.

thanks

Hi @eilongold2503

Car

  • Type (field type > text or option set display)
    Contact
  • 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.