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.
We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!
Hello. I hope somebody can help me:
I am trying to sum several columns in my file, there is no formula to do it.
the best way I know is to:- use "transform" tool - this way you will have values in one column and column names in the other
- then you can sum the column with values
- and then "Cross Tab" it back to the original formPlease let me know if this helps.
Awesome and interesting article. Great things you’ve always shared with us. Thanks. Just continue composing this kind of post.
Dollar General Survey
You can do so by using the Formula tool, just make sure all are numeric with Select or else.
Example in the attached screenshot.
Have a good day!
Hi @IsaacRamiro ,
You can achieve this output in 2 ways:
1. Easiest way would be to use formula tool and sum the columns.
2. Second is little bit lengthy but a good learning way to achieve the output.
I have attached the workflow for both, you can use any of them.