I have a filter that is calculating the count of inventory:
Expression: Count([Inventory Bascom Item Type])
Frequency Expression: Bascom Inspection Frequency
Month Expression: Month
And I want it to change based on a Frequency OR Month selection. SO if I select frequency "monthly" it does count only inventory that has a monthly inspection but I also want it to count if I select month Feb it counts the inventory twice, and if I select March it counts it 3 times. Can that be done?!
The thing is I also need it to count based on the months that are selected. It sounds a bit complicated but when a Month is selected let say March, then I want the inventory to be counted *3 since it's three months. But if Frequency Monthly or Quarterly or Annually is selected it counts the inventory for those.