Error in Alteryx Gallery

Question

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.

BrandonB · Answer

@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

becca51178 · Answer

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.

TheOC · Answer

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.yxmd