Dividing each cell of excel sheet by (1024*1024)

Hi All,

I want to divide all the cell values of an excel sheet by (1024*1024), i.e. dividing twice with 1024. I was using like this:
row(“create_pdp_success_ratio”) = (Convert.ToDecimal(Convert.ToDecimal(row(“create_pdp_success_ratio”).ToString)/1024)).ToString(“#.00”)

In an assign activity. But that is throwing runtime error. How to accomplish this?

@Ananya_Ghosal Your condition is working fine, there might problem with input value or datatype of column. Please check on this two things.

Yeah… Actually there were some “N/A” values. I used a try…catch for that and its working fine now. Thanks! @Manjuts90

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.