Availability Per%

[HAmzehAF]

i want to know the Availability for the products in the stock if its 5 or less to 0 

i was using this set analsis but its not working i get 5 until i choose a store and i get 1 1 1 1 1 1 for everything 

any ideass on how to do it ? 

count({<AVb_Stock={'1'}, Date={"$(=max(Date))"}>} distinct Stock)    

and the table 

Daily_Stock:
LOAD
"Date",
"Year",
"Month",
"Day",
DT,
PRODUCT ,
DESCRIPTION,
PRODUCT as sku,
Price,
WAC,
REFERENCE,
SUPP,
SUPPLIER,
"DIV",
Division,
GRP,
"Group",
CTG,
Category,
SGRP,
SubGroup,
BRAND,
Brand,
STORE_ID ,
Stock,

if(Stock<0, '1','0') as NegSFlag,
if(Stock<=5 and Stock>0,'1','0') as AVb_Stock,

[JHuis]

But are you trying to archieve this in the front end or the scripting before?