Error in Alteryx Gallery

[becca51178]

I have a workflow that I run on my desktop app with no issues. When I try to run it from the gallery I get this error

Now when I run it from the desktop app the error doesn't happen. It's only when I run it from the gallery. I have tried every way to fix the formula and nothing is working. This is what I have now that is still throwing an error. All I want to do is have the formula look at a number column which is currently formatted as Double and if it is more than 10M then it says "Greater than 10M"

I have tried several variations that doesn't have "To String" in front of it. The output is a VW_String format. I am not sure what else to do. 

[TheOC]

hi @becca51178 

assuming that your [CCy1...] field is a numeric, you dont need a tostring output. your "greater than 10m" is a string, and null() is a valid output for a string. 

Heres a quick example with a formula that works

[becca51178]

I made the change but it's still throwing the error. 

This just started. I had no issues with these workflows running on the gallery and now all of a sudden they keep getting throwing errors on this formula. Its just bizarre. 

[BrandonB]

@becca51178 your CCY1 GL Ending Balance value may currently be a string and therefore trying to compare it to a number will throw an error. Can you change it to ToNumber([CCY1 GL Ending Balance (ABS)]) in your formula