Skip to main content
Question

reports not pulling required information

Our company bids construction projects to multiple Contractors at a time. I've set up our bid table to link to the company table and can select multiple companies for each bid created. When I do this, the actual bid shows all that we bid to but the company itself does not show it. This is skewing out metrics quite a bit. Anyone know how to fix this?
      This topic has been closed for replies.

      • JohnJohn2
      • Author
      • Registered
      • March 27, 2017
      When you use a multi select field like there are limitations and benefits compared to having a "proper" child table for bidder companies.

      But here is a formula to count the number of bidders in that multi select field.

      var text $value = ToText([Bid To]);

      Count(
      Trim(Part($value,1,";")),
      Trim(Part($value,2,";")),
      Trim(Part($value,3,";")),
      Trim(Part($value,4,";")),
      Trim(Part($value,5,";")),
      Trim(Part($value,6,";")),
      Trim(Part($value,7,";")),
      Trim(Part($value,8,";")),
      Trim(Part($value,9,";")),
      Trim(Part($value,10,";")),
      Trim(Part($value,11,";")),
      Trim(Part($value,12,";")),
      Trim(Part($value,13,";")),
      Trim(Part($value,14,";")),
      Trim(Part($value,15,";")),
      Trim(Part($value,16,";")),
      Trim(Part($value,17,";")),
      Trim(Part($value,18,";")),
      Trim(Part($value,19,";")),
      Trim(Part($value,20,";"))
      )
      Terms & ConditionsAccessibility statement