Invalid Formula regardless of values

[sferabolli]

My data source formulas broke after re-adding the source with one new text column.

The same formulas work fine on the original data source. I've tried copy/pasting, rewriting the formulas, and even excluding the working formulas from the original source, but no luck. Any workarounds for this?

New source:

Old source:

[GavinW]

The only difference I see between those is that the scope of one of them is 'Embedded' and the other is 'Reusable'. You can see this on the top left of the each image.