Computatioin Error with Formula

building reports desktopintelligence
1

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)

2

At 04:08 PM 1/21/2000 -0500, Jamie Forbes wrote:

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.

Jamie, have you tried to create a new table (maybe on a new report tab), which links the two “Data Providers” (queries)?

When the results are linked into a single table, you should be able to reference both.

Anita Craig
Stanford University

Listserv Archives (BOB member since 2002-06-25)