Search results for query: *

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!

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...

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]]

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

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

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"...

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...

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...

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.

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...

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...

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...

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

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...

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)...

** 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...

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...

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...