How to remove sign by looking Dr/Cr Value

[rks4242]

Hi Experts, 

Please help me to know, how do I convert the local currency to Only number. 

Excel we do - 

Step 1 = if (D4="C".-1,1) 

Step 2 = D4*E4 

But I am not sure how do I write it in Alteryx 😞 

Rajat Sahu

[Qiu]

@rks4242 
Can we just use an ABS function?

[Qiu · Accepted solution]

@rks4242 

Followed your steps in Excel