E-mail Tool Error when column Missin

[Inactive User]

Good morning,

I have a workflow that delivers e-mail report internally.

I use locations as variable to define the sum of sales.

But when one of these locations is missing (days without sales) I have error and block the mail sending to other locations.

I have a formula tool and a summarize using these variables.

Any ideas?

Regards,

Tanai

[DavidP · Accepted solution]

So you're getting an error because a specific column does not exist after crosstabbing. You can circumvent this by checking if the column exists before the crosstab and insert it if it does't exist.

That way, you will not get the error in the formula and summarize tools.

[Inactive User · Accepted solution]

Thank you!

I'll save it.

I've found another one simplier.

Using the cross tab to get the total, without referring the column name.