Skip to Content
0
Aug 16, 2023 at 07:13 PM

Counting a Percentage Banding

76 Views

Sorry, I know this is a simple question but I have brain fog today.

Using Webi 11 3.0

I have percentage figure against supplier activity and have created a dimension to band the performance together

=If([Percentage]Between(0;0.799);"0 to 79%";If([Percentage]Between(0.8;0.899);"80 to 89%";If([Percentage]Between(0.9;1);"90 to 100%")))

I now want to create a Measure which will show the total number of suppliers in each of those bands.

I would also like to show that total against different categories, so for example the number of Suppliers within a Food Category which are in the 80 to 89% band, in the 90 to 100% band etc

Thank you for any help in advance