Format Percent

[danielfinzel]

Hello -

Im trying to calculate a total % for my employees production. I have one table (TechProduction ) that contains 2 columns (Production) and (Fails)and in my report I'd like to be able to see a percentage for total production, attached is a picture to give a better understanding. The formula I currently am using is

=FORMATPERCENT(DCOUNT("[ID]","[TechProduction]","[Production]")/[Fails],2)

However it is not working.. Ideally, I'd like to just use the numbers generated from the two text boxes to the furthest left of the ones showing the formulas i've tried, the name of those boxes is (Prod)and (Text41). Those text boxes are the totals of production and fails generated from the sum of the production and fails in the report. However, everytime i have tried to do a sum(prod)\(text 41) it delivers a pop up that i manually have to enter the numbers upon running the report. Please let me know if i need to explain a bit further.

Thanks in advance,
Daniel
[IMGNOTHUMB]http://bytes.com/attachments/attachment/7779d1406223193/error.jpg[/IMGNOTHUMB]

[twinnyfo]

Instead of "Sum(Prod)/Text41", try "[Prod]/[Text41]"

[danielfinzel]

twinny - I see what you mean there. I tried that and it still didn't work. However, it put me down the right path. After doing this I created 3 more text boxes, these boxes just took the sum of 3 different columns. I then made them not visible and performed the operation from those text boxes and it worked..I guess it didn't like it when I did math from one box and had another one relying on the math of the first one. I know that sounded very confusing..basi cally as soon as I gave it a number to pull, instead of an equation it worked.

[twinnyfo]

Glad to hear that you could work this one out. Have a great weekend!

[NeoPa]

Your reference to DCount() in :

DCOUNT("[ID]","[TechProduction]","[Production]")

is not correct. Check the Criteria parameter.