Hi, I am trying to create what should be a simple formula but can't get anything to come out.
Our plumber charges for labor by charging $650 per plumbing drop.
So to calculate this all I need to do is create a formula that adds all sinks/toilets/refrigerator/baths/showers and charges $650 per item.
I have been trying to do this by adding a material definition that uses the symbol type, and setting it to find library items that are tagged Bathroom/Tub/Sink/Plumbing etc. and then calculate the quantity with a set price of $650 per item. Yet nothing happens. I have never used a symbol type material definition so I'm in uncharted territory.
Yes, I know I could use the Bath fixtures/Kitchen fixtures etc library items in the softlist report, but that would make our accountant have to change how they do their reports, and this should be a simple formula to make anyways.
Here is what my formula looks like so far