Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEACool Challenge!
Started by filtering out those that didn't fit the date criteria first, this made it easy not to forget this later.
Then joined to the lookup table, and concatenated the order on ticket number. Then checked for the values required with an IIF statement, and calculated the final percentage with a final formula tool.