Forum Discussion
Solved
Using "Latest" date function on visual
Hi all, I am working on a production report. The issue I am having is between two tables. The first table is production order header and the second is called capacity ledger entries that contain...
My table was filtered yes. The table that I was trying to pull the data from was what was giving me an issue. I still don't know why but I solved the problem by copying the query that was giving me the issue, and using MAX to display the latest date per operation on the query.
I noticed that if I take off the "latest" then the report blows out and I have many rows for the same part because multiple dates are coming through. However I still don't understand the reason for this behaviour.