Sum across rows

[amandacastro]

So I am trying to use a formula tool, I have columns like:

State         City Locaiton           Zip Location        Revenue

CA             Los Angeles            90012                  100

CA             San Francisco         94012                   15

CA             Los Angeles            90019                    99

How can I use the formula tool to sum for City Location = Los Angeles? I am trying to get the revenue than organize by Zip location with city of Los Angeles only.

Thanks!

[PhilipMannering · Accepted solution]

Hi @amandacastro 

Is this what you're after? Total revenue for Los Angeles - see below,

[Qiu]

@amandacastro 
Hope this is what you need.

[joshuaburkhow]

@Qiu Just a friendly suggestion - you wouldn't want to do this (specifically filter in this case) in practice as its not scalable. If you look at what @PhilipMannering has done you will notice that if @amandacastro comes back with not just Los Angeles but maybe San Diego and San Francisco his solution still works with no changes! 

A good rule to follow is to build workflows that can scale, more often then not they take the same amount of work 😉 

Hope that helps! 

[Qiu]

@joshuaburkhow 
Thank you for the suggestion.

I guess you are right and flow will only work strictly for one condition, not so dynamic.