Report Footer dividing 2 fields cannot get the correct figure to show (1 Viewer)

[Joe8915]

Field Name A
=Sum([Piece]+[Summary detail]+[PartialSum]+[Summary Partial]+[WVSum]+[Summary wv]) = $53.53

Field Name B
=([ClockHrs]) = 8.50

I want to divide field B into field b

It shoud come out to read 6.50

I have tried everything but cannot make it read 6.50:banghead:

What in the heck is going on?

Thanks for taking the time to view this

 

[pbaldy]

What rules are you applying that would cause something the evaluates to roughly 6.3 to display as 6.50?

 

[Joe8915]

Paul, thanks for the quick reply.......... I am using the formula that the client has given to me from a excel file. It should come out as 6.50. I mean 8.50 divided by $53.53, shoud read 6.50

 

[steve21nj]

Can you post that formula that gives an end result of 6.5? Basic math gives a number of 6.297647058823529, so the formula may round up or down to the nearest .5.

 

[Joe8915]

Steve, thanks for chiming in. I will do even better. I will upload the db so you can see the report and give me suggestion on what I did wrong

 

[pbaldy]

Try

=Sum([Piece]+[Summary detail]+[PartialSum]+[Summary Partial]+[WVSum]+[Summary wv])/[ClockHrs]

 

[steve21nj]

pbaldy: i'm getting a total of 6.3.... I think we still need the excel formula to help.

 

[pbaldy]

What Excel formula? The mathematical result of your calculation is roughly 6.3.

 

[steve21nj]

Paul, thanks for the quick reply.......... I am using the formula that the client has given to me from a excel file. It should come out as 6.50. I mean 8.50 divided by $53.53, shoud read 6.50

Joe had mentioned that the end result was 6.5, based on the excel file that his client had given him. I was asking if he could post the formula from the excel file to see how they are getting 6.5 instead of the 6.3

 

[Joe8915]

What Excel formula? The mathematical result of your calculation is roughly 6.3.

I got the equation from a excel spreed sheet that was sent. I hope that kinda explains it. If you need to see the spread sheet I should have that around here as well?

 

[Joe8915]

Try

=Sum([Piece]+[Summary detail]+[PartialSum]+[Summary Partial]+[WVSum]+[Summary wv])/[ClockHrs]

That did it,thanks ever so much. I thought I tried every Combination there was

 

[pbaldy]

No problem.