Format not supporting

Question

Hi Team,

Request your valuable solution on the below issue i am encountering

I am trying to summarize the set of data. In one of the Gross Value column all the values are getting sum up but for few of the records it says

Test Value: ($0.29) is not a valid number

Test Value: ($0.00) is not a valid number

Test Value: ($6526.29) is not a valid number

I tried to change different type using the select tool but still these type of error i am getting. In my source data this particular Test Value column has the value with the $ symbol.

But when i just group by all the records am getting the desired output. But only when i group by and sum the Test value column i am facing this missing records.

Thanks,

Jeyaraj M

joshuaburkhow · Answer

Hey @Jeyaraj_M

It looks to me like those might be negative numbers since they have parentheses. You'll want to use the formula tool with a replace function to replace the "($" with a "-" and then another replace for the ")" to "" [nothing]. Then once you do that you can set to a number 😉

Qiu · Answer

@Jeyaraj_M 
Maybe this will help.

The Group by Tool dont really care the data type, while the Sum will require the field to be numeric.

Therefore, lets change it to numeric first and I support the () means minus value.

1210-Jeyaraj_M.yxmd