Subtracting a number from a known variable

[akinch001]

Hi all,

I am trying to do a simple subtraction with the formula tool. [Net Assets]-100000. Is is not possible to subtract a general number/amount from a known variable?

[Qiu]

@akinch001 
Can you give us a bit more information, liek input and desired output?

[AngelosPachis]

Hi @akinch001 ,

This is a long shot in the dark to understand why the subtraction is not working for you, but can you make sure that the [Net Assets] field type is numeric (i.e. float, double or Int).

Alteryx allows you to subtract values by the expression you used, so the only reason I can think of that prevents you from making that calc is data type mismatch.

[grazitti_sapna]

Hi @akinch001 , unless and until the variable Net Assets is int  or double type the subtraction should work. Please refer to the screenshot.

The following can be the issues as per my understanding:

1. Net Assets is of string datatype.

2. The formula might be used like Net Assets-'1000000' where '1000000' denotes a string.

In case this helps kindly mark this post as solution.

Thanks.