How to remove sign by looking Dr/Cr Value

Question

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 · Accepted Answer

@rks4242

Followed your steps in Excel