Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi i have the following problem.
i wish to break out returns ( where only a return has been made) from sales + returns on the same receipt.
below is my dataset my desired result
Receipt Type Amount
1056 Return 500
1056 Return 100
1030 Return 300
ie. Result should show 300 and count for only Return rows should show 1.
i have attached a qvw to easier illustrate the issue.
Best
Brad