Skip to Content
Author's profile photo SESHA PS

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.



Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Michael Bennett
      Michael Bennett

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


      Author's profile photo SESHU PS
      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 .,a%20new%20field%20%2D%20Associate%20dimension.