stock availability ratio

[#1]

Hi All,

I'm trying to report my stock availability. My data is consist of three fields; "Product Group" , "Part Number" and "Stock Quantity"

I've got 200 part numbers, 180 of them are in stock ([stock quantity]>0), 20 of them out of stock ([stock quantity]=0).

How can I make a presentation that says 90% available, 10% not available? And if I filter product groups I can see their availability ratios.

I've attached a sample data for your reference.

Thanks,

Mem

[#2 · Accepted solution]

Hi,

The following expression should give you what you are looking for. I have wrapped it in a Num function in case you want to put the expression in a Text Object.

=Num(Count({$<[Stock Level]={">0"}>}[Stock Level])/Count([Stock Level]),'#,##0%')

I hope this helps.

Thanks

Nick

[#3]

Spot on! Works beautifully. Thanks Nick.