Skip to Content

Count Incorrect in Webi

Hi Experts,

I have an webi report block data below which results as Count(Employee Name) =18 below:

Organization Name Count(Employee Name) Employee Name

Calsoft 1 Mr. Vinoth

Calsoft 1 Mr. Trios

Calsoft 1 Mr.Ubres

Calsoft 1 Mr. sheik

Calsoft 1 Mr. Muthu

Calsoft 1 Mr. Sujay

Calsoft 1 Mr. Dinesh

Calsoft 1 Mr. Mani

Temenos 1 Mr. Ranjith

Temenos 1 Mr. Vinay

Temenos 1 Mr. Arun

Temenos 1 Mr. Vignesh

Temenos 1 Mr. gauruv

Temenos 1 Mr. Kalyan

Temenos 1 Mr. Sathish

Next 1 Mr. Kanan

Next 1 Mr. Kanan

Winsoft 1 Mr. Karthick

Hidden dimension in below block is Cal Day

After removing Employee Name in the block, Count(Employee Name) =12 as you can see below:

Organization Name Count(Employee Name)

Calsoft 5

Temenos 4

Next 2

Winsoft 1

Couls you help with the webi formula on Count(Employee Name) column to get the data as below:

Organization Count(Employee Name)

Calsoft 8

Temenos 7

Next 2

Winsoft 1

Appreciate your quick help.

Thanks,

Dinya

Add comment
10|10000 characters needed characters exceeded

  • HI,

    Did you tried

    =Count([Employee]) IN (([Organization])

    Thanks,

    Jothi

  • Is there any duplicate name in calasoft? I can see here all unique..

    It will be good to understand if you will share the screenshot

  • Hi Amit&Jothi,

    Thanks for your quick turn up, yes Employee name is unique here provided for reference, we need to exclude Employee name in in table/block but include only in formula context.

    Thanks,

    Dinya

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 16 at 09:47 AM

    try with this formula.if there are some other dimensions in the report which are not included in the table then include those in foreach and see.

    =Sum(Count([Employee Name])) foreach ( [Employee Name])

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 12 at 08:51 AM
    Add comment
    10|10000 characters needed characters exceeded