Skip to Content
0
Jan 29, 2020 at 08:18 PM

How to avoid regrouping variables

22 Views

Hi!

I have a report with the following columns:

Account Number / Account Type / Financial Trans Description / Financial Trans Code / Date

I need to know the average transaction per account type for three different months for each type of transaction. I need a result to show for example: In 201807 (July, 2018) POS SALES have an average of 9 transaction for the "Save Account"

The accounts numbers are duplicated because a customer can do a transaction multiple times per day. Since the account numbers are unique I can count them. I only need to count the account once even if it duplicates. The problem is that, even though Financial Trans Code are a unique number also for each transaction (for tracking purpose) I cannot count them because they regroup. For example if I have 1, 2, 3, 4, 5... 100 different numbers instead of counting from 1 to 100 to know the total, the program gives me the value of 100 (as a group) and a count of 1. I have the correct total of account but don't know how to get the correct total of transaction to calculate the average.

In other words, it works that SAP counts the duplicate account number as 1 but no the transactions. The customer only have one account but have different transactions.