I have a report for the inventory, this inventory can be done every day ...
I would like to extract the LAST inventory of the month.
For now I'm only able to have all the month, = sum of all the inventory reported during the month, which is obviously not the right situation.
Many thanks in advance for yoru help.
Bruno
4 answers
Hi Bruno,
Create a formual field with return type checkbox, on Inventory object. formula would be if creation date is equal to Current month last date then true.
Now use this field on your report filter.It'll display only last day Inventories.
