CONDITIONS/Filter and multiply by -1

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.

CONDITIONS Muliply by -1.xlsx

Datasets

Input

Data Investigation

Accepted answers

KrishnaChithrathil

@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.

All comments

KrishnaChithrathil

@PassION_es

Could you please have a look??

Please mark it as a solution if it works.

Good day !

Filter and multiply by -1.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703