I am getting an error while removing the subscribers work from a coloumn

YT channel opertions 2.zip (16.9 KB)

guys can any one check my work flow and find rectify the error or edit the work flow and resend it to me

error:Write Cell: Expression Activity type ‘VisualBasicValue`1’ requires compilation in order to run. Please ensure that the workflow has been compiled.

regards

@Adithyeshwar_goud
CDbl(item(“subscribers”).ToString.Trim.ToUpper.Replace(“SUBSCRIBERS”, “”).Trim).ToString

Try this hope works

@Adithyeshwar_goud

first remove the subscribes and then convert to CDBL

(cdbl(item(“subscribers”).ToString.Trim.toupper.Replace(“SUBSCRIBERS”,“”).Trim)).ToString

Hi @Adithyeshwar_goud

Try this

cdbl(If(Not String.IsNullOrEmpty(item("subscribers").ToString), item("subscribers").ToString.Trim.ToUpper.Replace("SUBSCRIBERS", "").Trim, "N/A")).ToString

Hi @Adithyeshwar_goud

If(item("subscribers") IsNot DBNull.Value, Convert.ToDouble(item(0)), 0.0).ToString.Trim().ToUpper.Replace("SUBSCRIBERS","").ToString.Trim()

Regards