Subtract 2 String with Numeric value

[shivanand612]

Hi All,

I wanted to create a new filed called "Net" that will be the subtract the 2 fields.

Name	Target	Achieved
Closed accounts	100	80
Opened accounts	200	120

I want a new filed as below

Name	Target	Achieved
Net	100	40

The Formulae for Net is = Opened accounts - Closed Accounts

Thank you,

Shiva

[PatForData]

Hi @shivanand612 

You can try the attached method. Completing a double pivot to change the layout of your data making it simple to use a formula tool.

Hope this helps out!

Pat

[atcodedog05 · Accepted solution]

Hi @shivanand612 

Here is my take on it.

Workflow:

Hope this helps : )