cancel
Showing results for 
Search instead for 
Did you mean: 

Need COUNT

Former Member
0 Kudos

Hi experts,

In one of my queries I am using the characteristics Plant and Order. I need to the count of the total number of orders for each particular plant. Does anyone know how to do this? For example:

Plant 1 | Order 1

Order 2

Order 3

TOTAL ORDERS 3

Plant 2 | Order 1

Order 2

TOTAL ORDERS 2

Plant 3 | etc....

Thanks!

CM

Accepted Solutions (1)

Accepted Solutions (1)

former_member188325
Active Contributor
0 Kudos

Hi,there are many workarounds to get this depending on your Query design and data.

Try this out: Create a new formula COUNT(keyfigure) .Set Calculate Result as 'Summation'.

So this column will restun number of Orders for a plant based on KeyFigure.

And Set 'Suppress result rows' to Never for Caracteristic 'Order'.

i assume that you only palant and order in rows as shown in your example.

Answers (1)

Answers (1)

Former Member
0 Kudos

Thank you!!

Some of the values for my key figures are displayed as blanks - and thus are not counted - any workaround for that?

former_member188325
Active Contributor
0 Kudos

hi,in that case,you may create a fomrula variable on 'Order' and a new formula COUNT(formulavariable on Count).So this formula should return 1 regardless of KeyFigure value.Let me know if this doesnt work.