Hi,
I have 2 formulas, TeamsSignedOutForAllRptGroups and TotalTeamsForAllRptGroups. These yield integer values of 751 and 798 respectively
I need to make a third formula, the % of teams signed out. This is simply
TeamsSignedOutForAllRptGroups / TeamsSignedOutForAllRptGroups
But this comes out as 1.
I have tried
CDBL(TeamsSignedOutForAllRptGroups / TeamsSignedOutForAllRptGroups )
and CDBL(CDBL(TeamsSignedOutForAllRptGroups) /CDBL( TeamsSignedOutForAllRptGroups ))
but it still comes out 1.
I want it to come out .9411 (which is 751/798).
What am I missing to make it do this?
Thanks,
Dick