i need to make a report like this.
Date in out store
1 jan 100 50 50
2 jan 60 70 30
etc.....
in = a db field
out = a db field
looking for a query fore the store
Hi,
How is the store value derived? It's not clear from the example you posted how this is calculated...
MF.
Store needs to be calculated.
Yes, but how? What are the rules for calculating it?
There is no role, it's a count of goods in store. (number)
Hi,
I think we have a failure to communicate here! :)
If your database is not storing the count of goods in store, what formula can you use to calculate this count based on other values you do have?
For example, is it the OUT value subtracted from the IN value for each row? Your example above seems to indicate otherwise.
MF.