I'm building a few reports based on stored inventory vs. deployed inventory.
Without getting into the details of the individual reports, I am making simple reports based on 5 separate types of assets (10 reports total = deployed & stored per asset): Monitors, Laptops, Desktops, Surfaces & Docking Stations.
By default LS provides 3 columns for conditional reporting (i.e. like, not like, = ... etc.). Once I add a fourth condition, I receive "The multi-part identifier "<TABLE NAME>" could not be bound."
Is there a way to add or combine conditions that will conform to the 3 condition default, or will I need to get really creative on how the report pulls its data?