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!

  • Congratulations Mike Lewis 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. Paulo R

    CR Running Total distinct count duplicates

    Thank you but the report has that specific structure due to specifics from the software it's linked to related to pricing lists with multiple listings, different rules to determine price of model, or specific item, or marketing model, or customer model, or customer item, etc All links were...
  2. Paulo R

    CR Running Total distinct count duplicates

    Managed to identify via "suppress if duplicated" the duplicate data (which came from a RT that couldn't be used in this fation). Resorted to a running total + a formula to get the RT results. If the formula repeats, get's suppressed. Now I need to suppress the details when this happens (hiding...
  3. Paulo R

    CR Running Total distinct count duplicates

    Hello, Feel free to remove any and all groups, I'll work around that. Just need help to figure out the duplicate data. Thank you,
  4. Paulo R

    CR Running Total distinct count duplicates

    Hello, I understand and am uploading a sample of the report (with only the relevant data on it). And thank you for your help on this. Report File Cheershttps://files.engineering.com/getfile.aspx?folder=bd27f0ae-6e26-4f31-8adb-0c318fd490e1&file=Sample_Report_Data.rpt
  5. Paulo R

    CR Running Total distinct count duplicates

    Hi pmax999, Below the formula: if right({SPRICLIST.PLI_0},2) = "50" then {ITMMASTER_MDL.ITMREF_0} else if right({SPRICLIST.PLI_0},2) = "90" then {ITMMASTER_TSI.ITMREF_0} else if right({SPRICLIST.PLI_0},2) = "10" or right({SPRICLIST.PLI_0},2) = "12" then...
  6. Paulo R

    CR Running Total distinct count duplicates

    Hello all, Using this sample data, I want to count how many times each item shows. Group----item----expected result 1---------A---------1 1---------B---------1 1---------C---------1 2---------A---------2 2---------B---------2 3---------A---------3 3---------C---------2 3---------D---------1...

Part and Inventory Search

Back
Top