now I've done that - and then had a daily workflow to push the value into a stored field that could be accessed in reports