ContributionsMost RecentMost LikesSolutionsAdd button in embedded report Good evening, I have tabs set up in my parent table records, and in one of those tabs the information is a parent to a child table. I want the purple button to not show for certain case types in a drop down field in the parent record, or if the record has meet the outcome of having 2 reviews completed. Is there a way to do this? Re: Calculating 1.5 pay Apologies, let me try to clarify - I have a formula field that will calculate the Total OT Pay based on the Total Hours worked * OT Pay rate...but I also need to calculate based off of an exempt type employee who receives a per-diem rate. I'm not sure how to have the Total OT Pay reflect how much a per-diem person will receive. Re: Calculating 1.5 pay is there a way to calculate the total pay based off the Total OT hours field and a field that calculates the OT pay rate vs using a standard work week info? Re: Calculating 1.5 pay Thank you, this is very helpful! My current fields for entering in the date and time is the Date/Time field - should I separate these out and have 2 different fields for the date and time? Re: Calculating 1.5 pay It's a duration field, but now I've also realized I need to calculate hours between date/time fields. I have 2 date and time fields for each day of the week for the user to enter in the date work and time started and another field to enter the date and time work stopped - for each day of the week...how do I total those fields in my TOTAL Hours of OT Worked Duration field? Re: Calculating 1.5 pay The zero at the end redlines and highlights yellow with a message saying expecting duration but found number? the field is a formula numeric field Re: Calculating 1.5 pay I've tried this formula, but it doesn't seem to be working... If([TOTAL Hours OT Worked] > [Standard Work Week], ([TOTAL Hours OT Worked] - [Standard Work Week]) * [OT Pay Rate], 0) Re: Calculating 1.5 pay Thank you! So, another issue I've ran into is trying to find the best way to calculate the total pay the employee was paid based off the Total hours worked... I have a formula duration field that shows the total hours of OT worked based off work start and end times - not sure if I can use the Total Hours of OT worked to calculate the pay based off my OT Pay Rate field that is capturing my time and half pay? Re: Calculating 1.5 pay I currently have a field where the user enters in their base hourly pay and the overtime rate is at least 1.5 time the amount of the base hourly pay rate. Calculating 1.5 pay Is there a way to have a field calculate and display time and half pay from an hourly base pay field? Solved