Skip to Content
0
Jun 09, 2020 at 08:15 AM

Count Function based on multiple criteria in SAP BI Ojects BI Platform 4.2

130 Views

Hi SAP community, i am new here and new to SAP BI Objects 4.2 , I am trying to create a formula in SAP that counts the entries that match my criteria. At the moment i am only able to do a single layer count. I have a file attached that shows what i am trying to do. I was advised to use Input control but that is not what i would like to do.

My database is basically about support tickets.

At the moment i am using the formula Count([Department];All) Where ([Department]="Customer Services"), this gives me the correct results of single criteria but i need based on 3 criteria. I actually would like to achieve below:

Goal 1: Count number of tickets under Customer Services that are about complaints and status pending.

Goal 2: Count average days pending under Customer Services and are about complaints.

Please help and thank you in advance.