Can't understand the value I'm seeing

[Karl_Spratt]

Hi Community,

Sorry need some help please, as I can't understand the value I'm seeing

I have a formula which is: ToNumber([Hard__Demand]+[Soft_Demand])

if there is a value in the demand columns, these are a (negative) values, I've checked using the select tool, and both columns are (Double Type), I was using  ([Hard__Demand]+[Soft_Demand]) but in the preview I was seeing NULL

So I changed to ToNumber([Hard__Demand]+[Soft_Demand])

But in the example attached, I have  Hard Demand = 0, Soft Demand = -2  but my Demand Total is coming as 0, don't understand this, I want the formula to repeat, as i have the same item in various WH locations.  So I'm ok with that.

But I'd expect a Demand Value of 2 in the column, can someone explain what I'm doing wrong here.

TIA 

Karl. 

[afv2688 · Accepted solution]

Hello @Karl_Spratt ,

What you are doing by adding two string is concatenate them giving you "0-2". Alteryx is unable to understand this number and ignores everything after the dash.

What you would need to do is:

ToNumber([Hard__Demand])+ToNumber([Soft_Demand])

This would translate each number first and then do the operation

Regards

[Karl_Spratt]

Hi afv2688,

That worked perfectly.. Thank Man

Regards,

Karl. 

[Qiu]

@Karl_Spratt 

I also suspect as @afv2688 , and I was able to replicate the issue.

Can you check the workflow message, if there is a "lost in information in conversion" warning.

If yes, then it is the data type issue.

But you mentioned, you checked it is double as you have checked.

So maybe you can share your workflow even partially?