subtraction- getting error due to data type

[Kinetic_analytics]

Hello great people:

I want to deduct from TOTAL ALL EXPENSE to Sell Amount
     

TOTAL ALL EXPENSE	Sell Amount
414,966	414966.25
V-String            15	Double

I am using a formula tool to subtract and want to show in column but I am getting error.

Appreciate your help. 

[binuacs]

@Kinetic_analytics One way of doing this

[n8rushton]

I would recommend putting your data through a select tool prior to going into the formula. There you can adjust the stringed integer into an actual where you can perform math on it.

[ShankerV]

Hi @Kinetic_analytics 

There are many ways to do it, out of which 2 ways are below.

Note: The workflow used to achieve the solution is attached which can be downloaded to see how the solution works.

If you believe your problem has been resolved. Please mark helpful answers as a solution so that future users with the same problem can find them more easily!!!!

Many thanks

Shanker V