ContributionsMost RecentMost LikesSolutionsRe: Calculate a labor rateit's always a small thing that I miss :)Re: Calculate a labor rateI ended up with this and it works. then just had to format the field as currency. If([Wage]>=10000, [Wage]/2080, [Wage])Calculate a labor rateI am trying to calculate a labor rate from a field called wage that could either be an hourly rate or an annual rate. Here is what I have so far: If([Wage]>=$10,000.00, [Wage]/2080, [Wage]) I am lost. thank you for any help.Re: Create a field that totals up dollar amounts from invoices that are assigned to a specific agencyI have a similar question, I have an expenses table our field guys enter their expenses into daily. I need the "Food" dollar amounts not to exceed $40 a day and "Parking" not to exceed $10 a day for reimbursement purposes. I don't want to use form rules because I think people will be adding these in grid edit most of the time. Can I create 2 fields one to total any expense amounts in the food category for one day and then another field called expense payout total to be either the daily expense total or $40 whichever is less.