Forum Discussion
Track open work order totals
I have "Table A" that is similar to this: Work Order#, Quote Amount, Start Date, End Date A work order is in open status when it is started and not ended. I have a date dimensions table...
samdthompson
Memorable Member
Memorable MemberHi, i think you want to put in a calculated column for an open / closed flag. this will give you the ability to easily filter in your calculation.
you can then visulaise say by start date how many orders are open and what the value of those are ditto the closed ones.
// if this is a solution please mark as such