Workflow's Output Incorrect

Hello - I'm hoping someone can help me with the attached workflow. Basically, I have attached the Pivot spreadsheet that I need Alteryx to create as well as the workflow. When I run the workflow, the totals are not populating properly. Please take a look and let me know what I'm doing wrong.

Thanks in advance for your help.

June Report Update.xlsx

lisamccullough - Copy.yxmd

Workflow

Output

Help

Accepted answers

KarolinaRoza

Hi @lisamccullough

I agree with previous posts, in first Summarize tool you need to Group by PostCategory instead of Mode.

I spend some time simpyfing and correcting your workflow - it is attached 🙂

Let me know if you have any questions.

Karolina

lisamccullough_KR_version.yxmd

All comments

PeterA1

Hey @lisamccullough I took a look at your workflow. I am guessing based on what I see that the issue is happening when you take the mode in the first summarize tool. The mode is 0 for example on the [Adjusted Expense 2021] Field for example. Is this expected? My guess is the 0s are throwing off the other downstream calculations.

BA02

As Peter mentioned, due to those errors, Post Category is getting dropped as well.

In Report Type = FA, post categories are going missing because of this. My guess is, because of this you are not getting the correct calculations and incorrect number of records.

lisamccullough

Can I remove the MODE or update it? Someone else actually put this together and I'm building on it.

KarolinaRoza

Hi @lisamccullough

I agree with previous posts, in first Summarize tool you need to Group by PostCategory instead of Mode.

I spend some time simpyfing and correcting your workflow - it is attached 🙂

Let me know if you have any questions.

Karolina

lisamccullough_KR_version.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703