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,
