Search results for query: *

Skip, Thanks, I started rounding ,2 from the beginning of the calculation and that seems to be doing the trick. Thanks for all your help with this. Dom

Skip, Yes, that's what my second sentence outlines. The formatting/display of the value is different than what is actually used for calculation. Is there a way to combat this? I just can't remember running into this before. Thanks

Yes, I'm following where you are going but the quotient is stored in a cell defined with 0 decimals so the value is actually 9% or .09. These five values are then averaged producing a similar percentage with no decimals. Are you stating that what I'm showing as 9% and what is actually be...

C20 = 103,342 C26 = 9,000

Are you familiar with the link below? I ask because the percentages that are being provided are coming from formulas that look like this: =IF(C26=0,"0%",C26/C20) The c20 is the total from the pivot table and the c26 is a sum from select fields in the pivot table...

Hi Skip, For example. The percent value = 27.23% or .2723 * 28,000,000 The result should by 7,624,400 I get 7,624,820.06 $420.06 difference Dom

I am adding percentage values. These cells are NOT part of a pivot table but their values are calculated from pivot table cells. Option 1: =SUM(B22:F22)/5 Option 2: =(B21+C21+D21+E21+F21)/5 I then take the result from above and multiply this by a fixed value in another cell. The results...

Victoria, Thanks for your help. FWIW --- Just an update in case you experience this. After opening an incident with Microsoft they informed us that this is a known issue. I can't say if everyone experiences it however. It turns out that the slow login is caused because of too many entries in...

Yep, switching companies, and yes, happens on the server as sa.

We are using GP 9 Standard on a SQL 2000 Standard box. Single processor Xeon 3.06 with 3 gigs of ram. We have approx 25 GP databases running on this server along with 25 in another SQL application. It takes minutes to switch from one client to the other in GP so I'm wondering if there could...

Skip, Thanks, that should do it. Dom

I have an excel document that is utilizing various crosstab queries that are timeframe driven. Basically month and year. There are various months that have no data but I need the month to appear anyway. How can I force the month row to appear even if there is no data? 2005...

rjoubert, Tried =Sum([PERCENT USED]) but get a syntax error. Dom

I am trying to sum/total/add (whatever) a perentage value. This value is being pulled from a query. Haven't been able to get this to work. 2.5 3.5 4.0 --- 10.0 Also, what is the easiest way to round a percent to a whole number? 2.4 = 2 and 2.5 = 3? Thanks, Dom

We're not a large company (under 100) and was wondering how most organizations handle the providing of PDAs or Blackberry type devices. Is this purely a company expense, shared expense or individual expense? Thanks, DomP

Excel doesn't freeze but actually returns the data based on criteria entered from prompts. Promts were entered directly into the value field although I have checked the values in the prompt area itself. Not a huge amount of data. Could be anywhere from 300 to a couple thousand records being...

Geoff, The .xls file is tied to an SQL database. We just open the .xls document and click on refresh but no text for the prompts appear. Not sure what other info you would need and/or to ascertain whether it is or isn't a memory issue. Thanks,

Using Excel XP(2002). I have prompts that work sometimes and other times the prompt screen appears without the text. It accepts the values entered so the prompts are actually working, it's just the question that is supposed to be asked cannot be seen. Any thoughts? Thanks, Dom

hmmmm, interesting. I'm using 2002. Let me look into this. I'm trying to avoid having to do this in an Access report (that's where the data resides). People reviewing this will only be reviewing via hard copy so even with the functionality you mention the readability may not be there but I'm...

Dhulbert, Yes, that's what I've created. Readability is real important and I'm not happy with how it looks. It definitely conveys what I want but isn't quite clear enough.