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...
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...
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
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.