8 Replies Latest reply: Nov 12, 2013 7:53 AM by saurabh yadav RSS

how to count the value  in webi report?

Malik A
Currently Being Moderated

Hi All,

 

i am stuck on the problem it seems simple but i am unable to resolve it.

i have three columns 1. Service Number  2. Amount  3.Date. the report looks like

 

Service No     Amount     Date    

1234               55               1/2/10

1234               85               1/2/08

1234               65               1/2/10              

1235               74               1/2/06

1235               55               1/2/08

1236               65               1/2/09

 

i further filter this to get the data based on the most recent date. now the table looks like

 

Service No     Amount     Date    

1234               55               1/2/10

1234               65               1/2/10              

1235               55               1/2/08

1236               65               1/2/09

 

But now i have to create another column named "Count" which should show the count value of all Service No such that

 

Service No     Amount     Date            Count

1234               55               1/2/10     3

1234               65               1/2/10     3         

1235               55               1/2/08     2

1236               65               1/2/09     1

 

i tried to get the result by using the Formula =Count ( [ ServiceNO ] ; All )

but i was unable to get the desired result.

How can i solve this?

 

Thanks

  • how to count the value  in webi report?
    Jyothirmayee S
    Currently Being Moderated

    Hi,

     

    You are counting on SErvice NO. and trying to display the count on same level?.

     

    In your exmaple:

    Service No. 1234  has 2 different value 55 and 65 and then counting on same level.

     

    Reomove the service no and then you will see the total Amount and the count of Service No.

     

    What is the result you wanted to see though?.

     

    Thanks,

    Jothi

    • how to count the value  in webi report?
      Malik A
      Currently Being Moderated

      Hi Jothi,

       

      Actually i want to see result

       

      Actually i had a table where i have hide the repeating value of Service number, Now i have to create a column which should count the Total value of Service number.   example my previous table was like this

       

      Service Number    Amount    Date                   Count

      1234                        85          1/1/2012               1

      1234                        55          1/1/2011               1

      1234                        88          1/1/2010               1

      1231                        11          1/1/2012               1

      1231                         2          1/1/2011               1

      1241                         85         1/1/2012               1

       

      them i hide the duplicate values and table looked like this where i want to Count even the hidden values of service number. it should look like this :

       

      Service Number    Amount    Date                   Count    

      1234                        85          1/1/2012               3

      1231                        11          1/1/2012               2

      1241                         85         1/1/2012               1

       

       

      Thanks

  • Re: how to count the value  in webi report?
    saurabh yadav
    Currently Being Moderated

    Hi Malik

    As this is your table:- 

    Service No         Amount       Date   

    1234                       55            1/2/10

    1234                       85            1/2/08

    1234                       65            1/2/10             

    1235                       74            1/2/06

    1235                       55            1/2/08

    1236                       65            1/2/09

     

    You want to count for unique Service No but the table you showed below for the output its not possible to count on this below table, because for the Service No (1234) it will always count separately for each row.

    The count is possible if you remove the Amount ,

     

    Service No     Amount        Date            Count

    1234                  55               1/2/10               3

    1234                  65               1/2/10               3        

    1235                  55               1/2/08               2

    1236                  65               1/2/09               1

     

     

    if you will remove Amount the WEBI will show the Output table like

     

    Service No      Date           

    1234                 1/2/10    

                              1/2/10            

    1235                 1/2/06

                              1/2/08

    1236                 1/2/09    

     

    So you can see there is the format of the table , now you can use the formulae

    Count(Service No);all

    It will give you the proper output

Actions

Incoming Links