AnsweredAssumed Answered

AF Table lookup and daily Query: show zero when no value is found for the day

Question asked by MISugiyama on Jan 29, 2019
Latest reply on Feb 4, 2019 by gregor


It sounds like a very simple problem, but I am stuck with it, probably due to my lack of knowledge.


I have a query that brings me daily volume (VOL_20) for each product (COD_PRODUTO). When there is no production for the day, the query doesn't bring any data.



I have an attribute for each product to show the value. I configured a Table lookup as below, matching product and locations.



The problem is, when there is no data for the day for a product, the query simply does not generate anything for this product. The table lookup keeps showing the last value. I want to show no value. How can I accomplish that?