Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2008
    Posts
    4

    Unanswered: Calculate Busy Hour

    Dear Experts,

    I need a formula in crystal report which calculate the maximum value of data like in the below case it is 71798 and the formula should return the hour value for this maximum value calculated like in the below case it is 13



    HOUR data
    0 24285
    1 21030
    2 17659
    3 14217
    4 11550
    5 7542
    6 5651
    7 5503
    8 6561
    9 7839
    10 10644
    11 12699
    12 36137
    13 71798
    14 60418
    15 61061
    16 20453
    17 19224
    18 11803
    19 16697
    20 17048
    21 17828
    22 17167
    23 18240

    I am usingone formula but it is not returning me the correct hour value, it,s returning always hour= 23 i dont know why please see below the formula

    if {SALES.DATA}= Maximum ({SALES.DATA})
    then
    {SALES.HOUR}

    Plese help me to fix this problem.

    Take care

  2. #2
    Join Date
    Oct 2008
    Posts
    5
    What is representing this data. minutes, numeric values etc. What is scope of data field (Is it monthly, weekly, daily etc)?

  3. #3
    Join Date
    Nov 2008
    Posts
    4
    Hi,

    Data Field type is nummeric and has nothing to do with month week. so it only contains the number.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •