ContributionsMost RecentMost LikesSolutionsRe: Save as spreadsheet issueSo is the issue with quickbase or is with excel converting the field to something else? I can't have the client going into the import/export section to download. ------------------------------ Mr Delemar ------------------------------ Save as spreadsheet issueGood day, I have a report and one of the columns collects serial numbers, the serial numbers are 24 characters long. There are over 6000 entries. Every time anyone tries to use the Save to Spreadsheet option, the column opens in excel but one column is truncated. No matter how I save it, it does not pull the information down properly. For example it will change a number like this: 183412203011023907608178 to something like this:1.83352E+23 The only way to export the data properly is to go into Import/Export and export as a Tab-Delimited value, save it. Then copy and paste it into a new excel file. I want my client to be able to as they normally do, click on the Save as Spreadsheet on the report and be able to download the report with out any changes. The field in question is a text field. ------------------------------ Mr Delemar ------------------------------ Re: Selecting a yes/no field and dividing a result.Thanks, I think this is the right direction. The issue i have is as follows: High Volume field is a text-multiple choice lookup field to get the yes or no answer Surveyed printer field is also a lookup numeric field Required printer field is Numeric field, user inputs number Total New printers Currently the Total new printer field has this formula Surveyed printer field - Required printer field So what i would need to happen is the following: IF High Volume is Yes, do nothing, let the formula in total printers field subtract the 2 fields. IF High Volume is NO, then Surveyed printer field - Required printer field /2 and that answer should go in the Total New printers field. Hopefully this makes sense. Thanks again ------------------------------ Mr Delemar ------------------------------ Selecting a yes/no field and dividing a result.My current issue is I have a field that calculates the total number of printers needed per site (Total printers required field). That part works fine. Now I need to add an additional field that is a Yes/No question and if the answer is NO, then it will need to divide the number in the Total printer required field by half. Fields currently: High volume site - Yes/No If NO then divide the number in the "Total printers required field" IF YES then do nothing Total printers required field ( this is a formula field that subtracts from 2 other fields to get the totals.) How will i tell QB if the NO answer is selected then cut the number in the Total printer required field in half and return the result in the same Total printers required field? Any help will be greatly appreciated, I believe part of the issue is the fact that i have text and numeric formula fields. Thanks in advance. ------------------------------ Mr Delemar ------------------------------ Re: How to change a decimal to whole numberThanks, that work perfectly. How to change a decimal to whole numberI have a number field labeled QTY. I have another field labeled Final totals that looks at the QTY field and divides by 2. But if its a decimal i need it to round up to a whole number. For example: if QTY=7 the Finals Totals: 3.5. It should be 4 for the Final Totals. Is this possible with a formula?Re: Total item count issueEach of the 12 fields are calculating correctly. Its figuring out how to get the Total Item Count to calculate. For example field 1 = 15field 2 = 0field 3 = 10field 4 = 12field 5 = 0field 6 = 10field 7 = 10field 8 = 0field 9 = 12field 10 = 10field 11 = 12field 12 = 0 Total item count = 8Total item count issueI have 12 Numeric formula fields that add up the sum of multiple devices. I also have a Total Item Count field. I want to be able to show if any of the field items are greater then 1 then add 1 to the Total Item Count. So the field will only add to it if there is a number in one of the 12 fields. for example if only 6 of the 12 fields have an amount then the total item count will be 6.