Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello I need to get a count of Inventory, description and breakdown of inventory received date so that I can filter items with an aging of more than x months. I can get a count of inventory and description but am at a loss om how to filter according to aging. My fields are InventoryName, Description, InventoryDescription and ReceivedDate. Any suggestions would be appreciated
I'm assuming your count expression looks like this
Count( InventoryName)
and that X months is 6 months. If not then adjust these parts according to your needs.
Try this:
Count( {$< ReceivedDate= {">=$(=addmonths(today(),-6))"}>} InventoryName)