subtraction- getting error due to data type

Question

Hello great people:

I want to deduct from TOTAL ALL EXPENSE to Sell Amount

TOTAL ALL EXPENSESell Amount414,966414966.25V-String            15Double

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

Appreciate your help.

ShankerV · Answer

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

subtraction- getting error due to data type.yxmd

n8rushton · Answer

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.

binu_acs · Answer

@Kinetic_analytics One way of doing this