Dynamic Message

[LinhNguyen]

Hi,

I'm trying to calculate the number of rows with input as "0" and give a message with that count (without stopping the flow).

I used a count tool and got the number, then put it in a message tool. The problem is that in the message expression, I can either use [count] or "zero sales" but cannot combine them to create a dynamic message such as: you have [count] rows with zero sales

Is there any way to do this?

Thank you!

[BrianR · Accepted solution]

Try wrapping a tostring around the count - such as:

"You have "+tostring([Count])+" rows with Zero Sales"

[LinhNguyen]

Awesome! Thank you so much!!!