ContributionsMost RecentMost LikesSolutionsThe Sandbox locks the original appWhen I create a sandbox, it locks the original app - it does not lock out every user of the app only myself when I am playing in the sandbox? - is this correct?Re: Closing and Efficiency rates in QB reportI have created summary fields for # of customers and # of Sales what I am looking for is a closing and efficiency for the TOTAL of each sales person -If I create a calculated field it will always come up as 100% for each customer but I need to calculate on the TOTAL of each sales person Closing and Efficiency rates in QB report QB says that it can't be done but I don't see why it can't - its a simple function. I run 2 reports each week and then I have to manually put them in an excel spreadsheet to send out because I have 2 simple formulas in 2 colums - I have Sales volume divided by number of customers to get a efficiency and I have Number of Sales divided by Number of Customers to give a closing percentage, Now this is based on a Total of all sales specific to a division and to each sales person Example Sales Person # of Customers # of Sales Volume Efficiency Closing Joe Black 15 5 $58,189.64$ 3879.31 33.33% Curious George 33 $35,258.61 $11,752.87 100% I created 2 reports that give me the sum of all # of customers per sales person and total # of sales with volume per sales person but I need to be able to run a reportwith all of these combined into 1 report or at least 2 reports - QB should have the power to do this the other thing I was thinking is making an excel template to connect with QB so the report can up-to-date fields - I don't know how to do this so I would need to hire outside help. Any suggestions? By the way please keep things simple like I was a 4 yr old LOL - I Have knowledge of QB and built this app but with a lot of help. Thanks Re: How do I create a formula field that changes a date field to the the the current month?I am trying to create the formula - the error message is from the previous post - I tried a formula above and received an error currently I am having no luck What i am trying to do in an employee data base - is have a field that counts the number of years since the start date of employmentRe: How do I create a formula field that changes a date field to the the the current month?comes up with a bunch of errors when I add it to the formula. $mydate seems to be a big problem A variable declaration must end with a semi-colon. var date MyDate = [Start of Employment] Date]; Year(Today())-Year($MyDate DOB) - If( Month(Today())<Month($MyDate DOB) or (Month(Today())=Month($MyDate) and Day(Today())<Day($MyDate)),1,0)Re: How do I create a formula field that changes a date field to the the the current month?So I would just use my start date instead of DOB? so var date DOB = [DOB]; would become var date Startdate= [startdate]Re: How do I create a formula field that changes a date field to the the the current month?what is DOB?Re: How do I create a formula field that changes a date field to the the the current month?what is DOB?Re: How do I create a formula field that changes a date field to the the the current month?What is the $Mydate field suppose to be? I am working on something similar - I want a today's date or current date - I am trying to take a start date of employment and to count how many years that person has worked from "today's date - so it will change based on Today's date thanksI need a basic formula help I need to create a basic division formula Field / 1.16 or 16% I know it's so simple yet I am having issues