I’d like to link to a table and calculate the sum of a column, but I need the linked data to be filtered by a date field so that I am only summing the data from that specific date.
In my case, I need to count inventory items, but I want to calculate only the latest count numbers (summed by date) instead of summing every time I’ve ever counted the item.
In order to be sure that we understand correctly, may I ask you if it was possible to share your application (including information about table, fields etc.) to my colleagues email jan.pindak@tabidoo.com. It will help us a lot and we will be able to reply to your question asap.