# How to handle Aggregate Functions like (Count/Max/Min) in Webi Summary Report’s

How to handle Aggregate Functions like (Count/Max/Min) in Webi Summary Report’s.

Hello every one,

I would like to share how can we handle aggregate functions like Count /Max/Min for summary reports in Webi. Whenever we are working on Webi summary reports we will regularly face this issue like count /max/min will always show’s unexpected value but defined formula is correct.

Scenario: I have created one sample report which contains objects like EMP id, EMP Name, Emp age, Emp Sal and Emp type.

Note:  Emp id, Emp sal are measure objects and rest of all are dimension objects.

Now we got a request that report need to display :

1. 1. Number of employees under Emp type A & B
2. 2. Max Sal of Emp type A & B
3. 3. Min Sal of Emp type A & B

In general we will create 3 variables & we will apply (Count/Max/Min) function’s as  below :

• Number of employees =Count([Emp id])
• Max  Sal of Emp type =Max([Emp Sal])
• Min    Sal of Emp type =Min([Emp Sal])

If we do like this we will get incorrect values as below:

Possible solution is we have to convert Emp id & Emp Sal as Dimension objects & then we need to apply (Count/Max/Min) functions on newly created dimensions .

Hope, this document might be helpful for some of them.

Thanks,

Seshu

### Assigned Tags

You must be Logged on to comment or reply to a post.

I was interested in doing someting similar – question how to convert the dimension objects – I am a new user and learning all the time.

Thanks

SESHU PS
Blog Post Author

We have to create a new variable at  report level  with qualification  type  as dimension and in formula we have to use created  measure object.

follow the below mentioned document .

Thanks