Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Polarican0115

    Extract part of string

    I'm having trouble trying to get the accumulated total commission for each Sales Rep. How do I properly use variables for accumulating the total commission for each Sales Rep? Should I open a new Thread since this is off the original topic? I really appreciate all the help!
  2. Polarican0115

    Extract part of string

    That worked Pete, thank you!! I am also working on excluding rows to increase efficiency to help speed it up a bit, it does take a while to run. But without your help I would not be anywhere near this close. The only issue I am still having is the last part, trying to get the accumulated total...
  3. Polarican0115

    Extract part of string

    Thank you again Pete, I truly appreciate all your help! I followed your steps, but I received the following message for @BaseSalesRep after trying to run it the first time: [/URL]]
  4. Polarican0115

    Extract part of string

    Pete, please disregard the first attachment. The drop box link below should work fine. Thank you again. Erichttps://www.dropbox.com/s/l0d6b5027jrk89d/SlsRep_ext%20Table%20Data.xls
  5. Polarican0115

    Extract part of string

    Thank you Pete, I would appreciate that very much. I created a spreadsheet with all the data from that table. http://db.tt/iV6nGlru
  6. Polarican0115

    Extract part of string

    The image is kind of small. This is the detail I added to the screen shot: This is the actual table (Databasename.slsrep_ext) that I am utilizing to get the commission splits from, then group by Master rep Acct. All Master Rep accts will have a single value in the "user3" column. The "slrep"...
  7. Polarican0115

    Extract part of string

    I appreciate that Pete, but what you provided earlier did a great job helping me to match percentage based on position. Now that I have the split data, What I need to do is Group all MasterSalesRep accts with any SharedSalesRep acct they are part of. (Regardless of the position in the user3...
  8. Polarican0115

    Extract part of string

    Pete, Your assumptions were correct. 1. The data in the Contain Reps column are always separated by a space. 2. Your formula worked great for extracting the data from the Commission Split % column 3. There will only ever be 5 discrete pieces of data in each column. I am now able to get the...
  9. Polarican0115

    Extract part of string

    Thank you very much Pete. This was very helpful. I am still working through this because I have some issues trying to Group by what I pull out of "Contains Rep", but this was great to get me started.
  10. Polarican0115

    Extract part of string

    Crystal Reports 2011 Creating a Sales by SalesRep report. It must include any Sales that are associated with the Master Sales Rep. Many Master Sales ID's are also part of Shared Groups of Sales Reps (Shared SalesRep ID) Highlighted in Red is the type of data I need to capture. Please note: the...
  11. Polarican0115

    Crosstab Divide by Zero / Margin % Issue

    I ended up using a not so sophisticated work around, but it worked. When the Sum of Sales = 0, I figured I might as well just use the Margin$ value and add the % sign. Mathematically it works out the same anyway. I made this simple adjustment: whileprintingrecords; numbervar tot; numbervar...
  12. Polarican0115

    Crosstab Divide by Zero / Margin % Issue

    CR2011 I created a Crosstab report By Specialty Dept that displays Sales, Gross Profit and Gross Profit % by Order Type (Stock Sales/Direct Sales). The Problem I am encountering is when the Sum of Specialty Dept = $0.00 but the Gross Profit Margin has a value, the Margin % does not get...
  13. Polarican0115

    Combining like values from different fields

    Thank you Pete, that was extremely helpful! I really appreciate it.
  14. Polarican0115

    Combining like values from different fields

    Thank you pmax9999 //@whse if {orderlines.whse} in [ '001', '001p', '002', '011', '019'] then "001 Linden" else if {orderlines.whse} in [ '003', '004', '009', '017', '025', '031', '090', '092', '045' ] then "003 Houston" else if {orderlines.whse} in [ '005' ] then "005 Turtle Energy" else if...
  15. Polarican0115

    Combining like values from different fields

    Yes, thank you. I tried what you suggested and got the result I mentioned in the previous post. The formula I used (and did a group and sum on) was: if {@Whse} = '037' then {@Selling Whse} else {@Whse} What I can't figure out is how to get totals to combine when (whse = Selling Whse)...
  16. Polarican0115

    Combining like values from different fields

    ** The formatting of the report example on the previous post was not clear, so I re-posted with the correction. Thank you pmax9999. A Selling Warehouse is only required when an Order is created for Whse 004. The Selling Whse is set up with the same number convention as Whse. I created the...
  17. Polarican0115

    Combining like values from different fields

    Thank you pmax9999. A Selling Warehouse is only required when an Order is created for Whse 004. The Selling Whse is set up with the same number convention as Whse. I created the formula and grouped and summed on it. the following is what displayed...
  18. Polarican0115

    Combining like values from different fields

    Crystal 2011 I have a Sales Summary report that displays the following for 195 locations: Whse Sales Cost Margin$ Margin % 001 55555 33333 22222 40.00% 002 55555 33333 22222 40.00% 003 55555 33333 22222 40.00% 004 88888 66666 22222 25.00% 005...

Part and Inventory Search

Back
Top