I have a calculated field. I am trying to divide two queries. By themselves the work. But when I try to divide them to get a percentage it always returns 0

Calculated Field

(SELECT count(Director1) FROM shareholders WHERE Director1>0) returns correct count

(SELECT count(Email) FROM shareholders) returns correct count

(SELECT count(Director1) FROM shareholders WHERE Director1>0)/(SELECT count(Email) FROM shareholders) ALWAYS ZERO

I have verified that the number has decimals set to 2, it will not calculate

You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

## Question

## techguy

I have a calculated field. I am trying to divide two queries. By themselves the work. But when I try to divide them to get a percentage it always returns 0

Calculated Field(SELECT count(Director1) FROM shareholders WHERE Director1>0)

returns correct count(SELECT count(Email) FROM shareholders)

returns correct count(SELECT count(Director1) FROM shareholders WHERE Director1>0)/(SELECT count(Email) FROM shareholders)

ALWAYS ZEROI have verified that the number has decimals set to 2, it will not calculate

Any suggestions to divide these?

## Link to comment

## Share on other sites

## 3 answers to this question

## Recommended Posts

## Join the conversation

Note:Your post will require moderator approval before it will be visible.