Combine multiple $ value columns greater than value 1

[SeanM1]

Hello, 

I am trying to re-write the below formula in Alteryx and having issues accomplishing the task, below should generate a new field called 'Total Amount' for example.

IFNULL([_BIC_ZABUYAMT],0)+
IFNULL([_BIC_ZPBUYAMT],0)+
IFNULL([_BIC_ZTBUYAMT],0)+
IFNULL([_BIC_ZBCANAMT],0)+
IFNULL([_BIC_ZU_AMT],0)

[wdavis · Accepted solution]

Hi @SeanM1 

Would I be right in thinking that at the moment you have 5 fields that need to be summed together, then if any field currently contains null information then to apply a value of 0?

If so, the best way to do this would be to use a Data Cleansing Tool at the start of the workflow which will allow you to convert any Null Values into 0's.

You can then use a Formula Tool to add each of these Columns together. 

- From the drop down, select 'Add new Column' you can then type in the new field name 'Total Amount'

- in the expression box beneath, you can add together each of your fields. If you start to type their names it will present each field to you

- Use the + operator as you would do normally.

Let me know if that works for you. If you have any issues and can post some sample data, we can help to assist with a workflow.

Kind Regards

Will

[SeanM1]

@wdavis

Thanks, that actually helped a lot!