Prorata calculation - ARRGGHHH!

T

themasterspy007

I have a query that calculates a how many hours someone has worked in a given place and then pro ratas the wages to that place.

The problem comes is that the straight forward calcuation of [FullCost]*[ProrataHrs] sometimes generates a figure that is more than 100% because of other pay add ons

How do I create a the same calculation [FullCost]*[ProrataHrs] but get it to cap any figure that goes over 100% to 100%?

thanks

craig
 
R

Rob Parker

Perform the calculation on figures that don't include any "other pay add
ons". From what you've told us, it's impossible to be more specific.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with query calculation 2
Work Calculation Error with Multiple Resources 10
formulas for Actual Duration and BCWP 1
Vacation accrual based on years with rollover 1
bcwp calculation 0
Vacation accrual formula needed 2
Queries calculation 1
How do I create the formula for this calculation? 1

Top