I want to create a flowfield on the Item Table which finds the inventory count on the table REGARDING Date Filter on the Item Table. It would give a result like ‘What was the Inventory count by 010103?’ There is a field ‘Inventory’ which works just fine and doesn’t care about date filter. What I need is a field that looks ONLY for the upper bound of the date filter and does a sum on the Item Ledger Entry table. So far I haven’t found a way how to make this kind of a filter work. The standard methods take in only BOTH or NO boundaries. Any recommendations?
You should be able to use the OnlyMaxLimit in the CalcFormula Table Filters.
Thank you, Chris! It works.