Control Center Global Update Text vs Numeric

g8rb8t

I'm working in Control Center on a Global update to change a field from "N/A" to 0 (aka zero). When testing the update I noticed that it changes to the text of "0" as it's left aligned vs right aligned. Any ideas how to update from a Text to Numeric via Global Updates?

I've tried different variations to force numeric:

=Value(0)

=Value(1-1)

and others but when testing it throws the following error: "Error! Failed to update target sheet "[SCC Test] - test sheet name here" Code: 1137 - Message: Input collection contains multiple instances of the same element.)

Genevieve P.

Hi @g8rb8t

Any chance that the column you're updating is a Primary Column? Values will appear on the Left in a Primary Column, even when they're being recognized as numerical.

Otherwise, I would have expected the formula of =Value(0) to add the data in as a number. If this isn't working for you, I would recommend reaching out to Support with a screen recording of what you're trying to do, and the unexpected result.

Thanks,
Genevieve