Using Variables Without SubQueries

[FBandData]

Is there way to easily call values from another table to use as a variable?

For instance, if I have Business Branch A and want to divide all of the numbers by field value index in another table within a complex query, what would be the best way to do that?

There would be as many 50 variables in the query and each with its own index to divide with.

Table 1
Business Branch: A
Metric1: 500

Calculated Query:
Select Metric1/(Select Metric 1 From Table 1 WHERE Business Branch = "A") as Metric1Index
From BusinessMetrics

Is there a simple way to avoid the sub-queries and get the values into a query to use?

 

[xenou]

Where's the other table? What happens when you get to metric 2, or metric 3 (or Branch B, or Branch C)? This doesn't look like enough information to answer the question.
ξ