Hi the following code I am using as a filter on my card and have it set to "on list" its called skus to be purged
"CASE
WHEN On Order
= 0
AND (Future Demand
= '' OR Future Demand
IS NULL)
AND (Future Books
= '' OR Future Books
IS NULL)
AND (Reserved
+ WMAVAIL
<= 10 AND WMAVAIL
> 0)
AND WAREHOUSE_CODE
= 11
THEN 'On List'
ELSE 'Not On List'
END"
I have one more beast mode calculation called FBA/WFS that is not a filter but a field within my card itself I have created this calculation to identify whether or not the SKU coming in this filtered list is also in warehouse 18 or 19. Here is the code for
"CASE
WHEN SUM(CASE WHEN WAREHOUSE_CODE
IN (18, 19) THEN 1 ELSE 0 END) > 0
THEN 'Exists'
ELSE 'Does Not Exist'
END"
When I bring this FBA/WFS field into my card I am only getting "does not exist" I know my original filter for SKUs to be purged only has warehouse code 11 coming in and in my dataflow I am grouping by on SKU and warehouse code to get one SKU and one warehouse code per line. Is there any way where I can use the filter for SKUs to be purged which is filtering on warehouse 11 only but can also see if any of those SKUs from warehouse 11 are in warehouses 18 and 19 because there are SKUs with warehouses 11, and 18 and 19 in the dataset itself but not sure how I can display it on the card. I have also tried to add a formula in the magic ETL formula tile but that didn't work as well.