Skip to Content
avatar image
Former Member

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 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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Oct 27, 2015 at 10:35 AM

    Hi,

    try this.

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

    Amit

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 27, 2015 at 10:14 AM

    Hi,

    !.Create New Variable.

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

    Add comment
    10|10000 characters needed characters exceeded

    • 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.

  • avatar image
    Former Member
    Oct 27, 2015 at 10:20 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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..