How to calculate Total Count of Tran datetime

[Former Member]

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 Date	Customer Id	Tran Datetime
10/2/2015	XYZ	10:48:52 AM
		10:50:09 AM
		10:56:00 AM
		11:12:55 AM
		11:14:59 AM
	Total count	5

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

[amitrathi239 · Accepted solution]

Hi,

try this.

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

Amit

[Former Member · Accepted solution]

Thanks a lot Amit. This is working.

You guys are amazing.

God bless

[Former Member · Accepted solution]

Anwar..

If my response helps you in some ways...Reward me..

Coz i think mine is not wrong

[Former Member · Accepted solution]

Thank you too. It was first you who replied to my discussion.

Have a good day

[Former Member · Accepted solution]

Thanks for your kind reply..

If i helped..

Assign as helpful answer

[former_member220624]

Hi,

Create a CKF and put 1 and in the aggregation tab do an exception aggregation on 'Tran Datetime' and use the option Counter for all detailed values not null'

Hope it helps.

Regards,

Amit

[Former Member]

what is CKF ? Never heard about this.

I need formula to create this variable.

[Former Member]

Anwar,

Instead of Creating Variable.

Apply Formula in the "Formula Editor" for the particular Column..

Surely u ll get it

CKF--> Calculated Key figures..its used in BEX..

[Former Member]

Hi,

!.Create New Variable.

2.Apply formula as Count(Transdatetime) in (Business date)

[Former Member]

Hi Regina,

When I am using your formula it gives me total Count of Tran date on a given date. I want Total Count of Loyal Customer ID XYZ on a given date.