You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Reference variables turn (x) format for negative numbers into text

Received Response
edited Jul 24, 2019 4:10AM in Narrative Reporting 2 comments


Reference variables turn (x) format for negative numbers into text, so SUM(A:Z) doesn't work


We load a cell into a reference variable then use this to populate another sheet, a series of values, some reference variables are then summed,  (x) format for negative numbers appear to be turned into text so the SUM fails, despite the source being able to be totalled correctly

This means that SUM(A:Z) doesn't work, however strangely A+B+C...+Z does work

Is there anyway to alter the data type of the reference variable to cater for the (x) format

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!