Hi, Can someone advise how to add two value fileds and change one of them with the credit sign. Example below; I want to move the credits under Debit and have a minus sign?
@gsiva You can use formula tool for this. Please find the solution and accept it if this is what you needed.
Thanks!!
Hi @gsiva
Please find attached solution. Use the attached screenshot to see how you can move credit above debit.
Please accept it as a solution if this is what you were after.
Thanks,
@gsiva Can you please provide the output as well for the sample input you have provided if the solution is not the one provided above.
Hi Sapna,
I am looking for an output as below;
Hi Sapna, output as above;
Hi,
I am not looking to move the fields , what I am looking for is moving the values in those columns then make them as negative. output as below;
Thank you, much appreciated
PFA workflow FYR
.
Hi All,
Other than Formula method do we have any other method to add the multiple columns in Alteryx?
Thanks & Regards,
JayaPriya M
@Jayapriya , Try using multi field formula in case of multiple columns.
