Trumpetbob Member

ggenovese thanks! This worked great! Exactly what I needed.

Thanks @GrantSmith that worked with the ETL. I would love to sniff out APIs, but neither have the skills nor the time right now to do that.

& Yes! That was it. Thank you , that was exactly it.

I tried adding a +0 to the end of each statement, which works and shows a result. But I cannot filter by Lead level. Once I uncheck one it disappears again. ( -- B2 (SUM(CASE WHEN LeadLevel Name = 'B2' AND Contacted LIKE '%Y%' THEN 1 ELSE 0 END) / SUM(CASE WHEN Contacted LIKE '%Y%' THEN 1 ELSE 0 END)) *(SUM(CASE WHEN…

@ That makes sense. But when I do that I get no result again. If I limit to just one of the LeadLevel sections, it works for that one section. So something is still wrong.

Here is my sample data. With just one section of the Beast mode (B2) I get this: And this is what I get with all three. Here is my Beast Mode: ( -- B2 (SUM(CASE WHEN LeadLevel Name = 'B2' AND Contacted LIKE '%Y%' THEN 1 ELSE 0 END) / SUM(CASE WHEN Contacted LIKE '%Y%' THEN 1 ELSE 0 END)) * CASE WHEN LeadLevel Name =…

@MichelleH It returns a blank or "No data in the filtered range."

I have a solution to this. Set it up for importing an attachment as csv. I usually have the email subject wrong. Then send the confirmation email. Then go into the history and you will see the error with the yellow triangle with an exclamation point. Click on it to reveal more next. Some of the text in the message will…