Issue with Devices Calculation
Seeing "error" on Offices Application(Total Devices field) in Archer 5.5:
"Input string was not in a correct format."
The formula for field is: COUNTA( REF( [Devices], [Device Name]))
Acting very strange, mostly the formula does work on most records, but getting "error" only for 1 record only.
Getting the same error, only when there is a single value in a values list. In my case, I have nested values.
-- United States
If I select Canada I get the error. If I select both, it's fine. I suspect it can't handle the stored value of "North America:Canada".
Is your Devices field using nested values in a similar way?
It's a known error since 2014 with no planned resolution: