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. 

Capture.PNG

afv2688

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