Dear all,
I have the following data structure
Now I would like to just count the Expenses for a total year to get the structure below
Does anyone have an idea how to do that?
In excel I would work with a COUNTIFS function.
Thank you so much!
Hi @timol,
I have prepared a workflow for you.
The first summarize shows sum:
The second one show countif:
Thank you!!!
Hi @timol
Adding a bit onto @Emil_Kos solution, you can put the count and the sum in the same Summarize tool.
Company and Year fields should be group by, and then put expenses in twice, one as sum and one as count.
Cheers!
Esther
Sorry but One more question: How can I tell Alteryx to create a new column filled with the value of column "A", but if column A is null it should take the value of column "B"?
Would it also be possible to count values for e.g. 2019 and all years before that?
So assume that in the table above I would have data for the years 2015-2020. And I would like to accumulate values in every year.
But (for whatever reason) one company has only values for 2015, 2018, 2019 and 2020.
I still want to have values for 2017-2019.
So assume in the example below I would like to show values for 2016 and 2017 too (that are constant in comparison to 2015).
