I have 2 queries from the same universe in one report. I am trying to divide a formula from the first query by a formula from the second query. This only results in a computation error (#COMPUTATION). I have no problem dividing formulas originating from the same query. Unfortunately, I can’t get the figures I need in one query.
Here is the formula I am trying to create:
=Count(<Account Number(Query 1 with prkddlnk)>) In <Procedure Code Description - Long(Query 1 with prkddlnk)> / Count(<Account Number(Query 2 with prkddlnk)>) In <Procedure Code Description - Long(Query 2 with prkddlnk)>
Here’s a formula that worked fine:
=Sum(Count(<Account Number(Query 1 with prkddlnk)>) In Body) In (<Procedure Code Description - Long(Query 1 with prkddlnk)>, ) / Sum(Count(<Account Number(Query 1 with prkddlnk)>) In Body) In (<Procedure Code Description - Long(Query 1 with prkddlnk)>)
Jamie Forbes
St. John Health System
Detroit MI
Listserv Archives (BOB member since 2002-06-25)