Search results for query: *

Thanks - works like a charm! Laurie

It worked! Thanks so much... now if I can get it to work for all of them! Laurie

kchaudhry - its a string [7] this formula produced "Other" if ({co.cust_num} = "0100000" ) then "Lowe's" else "Other" synapsevampire - tried yours and got "Too many arguments have been given to this function" Naith - same result as synapsevampire Sample data: 10001 FIRST DATA CORPORATION...

I keep getting the "A string is required here" error. Thanks- Laurie

Hi - I've got a group GroupName ({co.cust_num}) and I want to change the output based on the customer number. I've created the following formula and placed it in the group header, but all I return is false. Any ideas? Crystal 9, SQL Example: if GroupName ({co.cust_num}) ="0100000" then...

Is there a way to re-establish the Field Heading and data link, so that when I move the data or field heading it all moves togeather? Crystal 9 / SQL. Thanks- Laurie

Thanks! That worked perfectly. I apologize for not posting all relevant data - as you can tell I'm new to all of this, but posted what I thought was all the data needed. You always seem to be able to help and I appreciate the time you spend answering questions. Thanks again. Laurie

Hello, I've got a report created that details open sales orders. Orders are pulled from {co_bln.co_num} If I drop in the field {co_ship.shipdate} then the sales orders that do not have shipments disappear and those with shipments remain. Is there a formula that can be created to keep all the...

I figured it out. I was placing it in the wrong area. Thanks for all your help! Laurie

Ok - my bad - I incorrectly described my setup. The crosstab is in the group header for slsman.slsman and then the data in the crosstab is sorted by item number. The crosstab looks like this: 01 Joe Schmoe Jan Feb March Total 0511 152.00 - 200.00 352.00...

Is it possible to change where the data is displayed? Let me see if I can explain it. Crystal 9 - SQL. Crosstab sorted by slsman.slsman and item number. The objective I'd like to accomplish: give the sales credit based on the item number to the corrected salesman. Unfortunatly, it is not...

SO # March Variable Cost Actual CM% 371900 $640.00 $394.88 38.30% 469500 $2,719.20 $1,093.12 59.80% Q1 Sales $3,359.20 Q1 Quoted Margin 55.70% Variable Cost:=(SUM(B2:B2)*(1-E2)) Quoted Margin:=-((SUM(D2:D3)/C6)-1) -Laurie

Thanks- I figured it out. Laurie

I've got the following data and would like to get the percentage based on the $ amount for the month. Can't average the %, due to the fact that the sales are paid per item... Here's a sample: $45 at 0% $37.98 at 27.36% $1311.14 at 43.30% $9360.00 at 99.19% Any help is appreciated. Thanks- Laurie

synapsevampire & kskid, Thanks so much for your quick response. The formula worked great and I appreciate all the help. Crystal is starting to make more sense now, so I shouldn’t have to ask as many questions. Thanks again. Thanks- Laurie

Hello again, I'm running Crystal 9 with SQL. I am pulling data from {itemwhse.item}. The subassembly part has an "-" some where in the item and the item can be various lengths. How do I supress the subassembly parts with "-"? Example: L7050089 24005389-002 1930015 5011 C1550341-002...

Thanks- it worked this morning! Thanks again for all your help. Laurie

Sorry - no error message, just output of: Item Extended Price K0040009 $140.00 M1370013 $376.00 Thanks- Laurie

synapsevampire- Yes, that is the formula that I used, but it doesn't work. Crystal 9 with SQL. Decrease the extended price by 50% for certain items, the rest to remain at 100%. example: Item Extended Price K0040009 $140.00 M1370013 $376.00 Output: Item Extended Price K0040009...

...example: Item Extended Price K0040009 $140.00 M1370013 $376.00 I tried adding this line to the extened price formula {co_ship.qty_shipped}*{coitem.price}... but it didn't work if {coitem.item}='K0040009' then (({coitem.price}*{co_ship.qty_shipped})/2) else Any help would be...