Announcements
cancel
Showing results for
Did you mean:
Partner - Specialist

## Average and calculated dimensions

Hey,

I want to show the Average Stock Quantity of the Top 5 suppliers.
Top 5 means the 5 suppliers with the highest Average Stock Quantity.

The calculated dimension works as expected. I get the 5 suppliers with the highest average Stock Quantity.

This expression works fine for the non-calculated dimension on the right side:

But on the left side, the value of "Sonstige" (others) is not correct.

Where is my mistake? 🤔

Labels (1)
• ### General Question

1 Solution

Accepted Solutions
Specialist

Hi @mruehl ,

Try this once :

=if(dimensionality()=0,

I believe this should do the trick. Let me know if it works for you.

Regards,

Rohan.

2 Replies
Specialist

Hi @mruehl ,

Try this once :

=if(dimensionality()=0,

I believe this should do the trick. Let me know if it works for you.

Regards,

Rohan.

Partner - Specialist
Author

Thanks a lot, it worked nearly perfect.
Calculating the average not by using the avg()-function did the trick.

I just had to do some small modifications:

if(
dimensionality()=0,