Alteryx Formula

[Khristian_Evans]

Hi, I want this formula to pick up on Charge type and State and if the following parameters are met to SUM everything after the word THEN. Can anyone help with correcting formula 

 

[cjaneczko]

For the other states are there any Null values in the AMT fields? You might want to data cleanse all of your AMT and TAX fields to make sure there are no null values in any of them. If there are and there should be you'll need to add some conditions on how to handle the nulls in the fields. 

[apathetichell]

While @cjaneczko has worked dilligently to try to help you here - your best usage of time is to WATCH THE TRAINING VIDEOS. That will help you identify what you need to build your formula and how Alteryx handles things like nulls.