Jeff – I don’t think you can imbed SQL into a Planner calc. You can use the ProfileString calc (if I remember correctly) to grab data from a text table that lives outside of Stratum. We’ve used this to grab things like the work days in a year, month etc. I supposed you could output the on hand to a text file and go from there. A bit messy but it could work.
