Hi Nicolas,

 INT = INT/INT * 100

@no_plan_rowcount or @member_rowcount must be FLOAT

MartinaJ

>Whats wrong with this.
>
>

>PRINT @no_plan_rowcount  
>

>
>returns 816
>
>

>PRINT @member_rowcount
>

>
>returns 416
>
>

>select @first_year_retention_rate = @no_plan_rowcount/@member_rowcount * 100
>
>PRINT @first_year_retention_rate
>

>
>returns 0
>
>What am I doing wrong .
>
>Thanks