I've run into this several times. You can't use table calcs to partition/address other table calcs. An alternative to having this capability (for me at least) would be to do the equivalent of a copy, past values on a table calc. This could be materialized in the extract, with the option to refresh it. As a materialized value, I should be able to then partition by it.