This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi @alteryxintern you can do this multiple way the simplest is using a summarise tool to group by Co_MSF and sum up all of your columns. However this is not dynamic as you would need to specify each column you want to sum. I've come up with two approach that should guide you.
Hi @alteryxintern as you mention the value are resulting in null because you are adding nulls in your caculation. You can deal with this in a couple of ways use a data cleanse tool before the formula tool to replace the nulls with 0. You can use a Multi-Field Formula tool to achieve the same affect with an If formula testing if the value is null and replace with 0. Or if you are using a crosstab tool such as I did in option B you can scroll down the method for Aggregating values in the configuration window of the cross tab tool and select total column which will provide that sum column for you.