CONDITIONS/Filter and multiply by -1

[PassION_es]

Hello Alteryx,

Needing your help to share to me your simpler formula on below.  I have an input data that generated activity and ytd balances from January up to December.

I would like to multiply to -1 all yellow column with this condition: If GL Account type (in orange) is a Liability, Equity and Income, then column K - column AH  (January - December) should be multiply by -1.

Attached is the dummy input file for your reference.

[KrishnaChithrathil]

@PassION_es 

Could you please have a look??

Please mark it as a solution if it works. 

Good day !

[PassION_es]

hello @KrishnaChithrathil , thank you. THis is what I am looking for however I am getting error when I incorporate it to my existing workflow because the field name changes from JAN OSOB FUCTIONAL TO JAN_OSOB_FUNCTIONAL (with underscore).  Field names should remain as is. Can you add a tool that return the header columns to each original names? Thank you in advance.

[KrishnaChithrathil · Accepted solution]

@PassION_es 

Use the last select tool for renaming the fields. Below is the reference image attached. Like wise you can update the rest of the fields.

Note - We don't really need that record ID there. you can remove it.