Expand my Community achievements bar.

SOLVED

Control group by data grouping causes Counting in progress forever.

Avatar

Level 7

Hello, I'm trying to use a control group for the recipients that their @ID ends with "10".

The way I've done it:

Heku__0-1706273769924.pngHeku__3-1706273971589.png

Heku__4-1706273978798.png

When I execute it freezes in the "Counting in progress" state:

Heku__2-1706273809600.png

The delivery has a valid target and if I don't use the expression Mod() this doesn't happen...

Any clue of how to fix this? Thank you in advance!

@Manoj_Kumar_ @ParthaSarathy @Parvesh_Parmar @DavidKangni

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hello @Heku_ 

 

How abut we do this?

 

Extract the last 2 character of PK first and then calculate the control group

Manoj_Kumar__0-1706399680187.png

 

 

Code to extract last 2 digits

Right(@id, 2)

Manoj_Kumar__1-1706399704459.png

 


     Manoj
     Find me on LinkedIn

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

Hello @Heku_ 

 

How abut we do this?

 

Extract the last 2 character of PK first and then calculate the control group

Manoj_Kumar__0-1706399680187.png

 

 

Code to extract last 2 digits

Right(@id, 2)

Manoj_Kumar__1-1706399704459.png

 


     Manoj
     Find me on LinkedIn

Avatar

Level 7

I would've prefered that I could do the expression in the delivery but this solution works. Thank you!