[FONT="]SKU Reason Code Total Cost Date[/FONT]
[FONT="]A123 5 100 1/1/2017[/FONT]
[FONT="]B456 98 200 1/2/2017[/FONT]
[FONT="]A123 98 300 1/2/2017[/FONT]
[FONT="]A123 98 400 1/3/2017[/FONT]
[FONT="]Hello All,[/FONT]
[FONT="]New to this forum. Looking for some support as I am stuck on a question.[/FONT]
[FONT="]Question Attempting to Solve:[/FONT]
[FONT="]Thank you,[/FONT]
[FONT="]Cam[/FONT]
[FONT="]A123 5 100 1/1/2017[/FONT]
[FONT="]B456 98 200 1/2/2017[/FONT]
[FONT="]A123 98 300 1/2/2017[/FONT]
[FONT="]A123 98 400 1/3/2017[/FONT]
[FONT="]Hello All,[/FONT]
[FONT="]New to this forum. Looking for some support as I am stuck on a question.[/FONT]
[FONT="]Question Attempting to Solve:[/FONT]
- In the table’s records above, SKU A123 has a Reason Code of 5 and 98
- When SKU A123 has a Reason Code of 98
- Then scan the table’s records to verify if SKU A123 has any Reason Code of 05
- If True, return the sum of Total Cost of SKU A123 for Reason Codes equal to 98 ONLY (answer = 700)
- If False, ignore/do not process
[FONT="]Thank you,[/FONT]
[FONT="]Cam[/FONT]