Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to calculate Total Count of Tran datetime

Dear Expert,

I am new to business object and need your help to create a variable to count Total Tran datetime of a Customer ID. I want to create this variable to identify how many times a day customer did the transaction to our Store.

Example :

Here XYZ customer made Total 5 Transaction on 10-Oct-2015

Business DateCustomer IdTran Datetime
10/2/2015XYZ10:48:52 AM
10:50:09 AM
10:56:00 AM
11:12:55 AM
11:14:59 AM
Total count5

So I want to create a variable which will count the total tran date time on a business Day for a Customer.

Please help.

Thanks in Advance

Former Member


try this.

=Count([Time]) In ([Customer ID];[Business Date])


0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question