Hi Guys,

I am trying to find the 10 percent of amount based on condition where “uber” is mentioned in Description field and place the value after calculating in the required field.

Amountcal.xlsx (8.8 KB)

Hi Guys,

I am trying to find the 10 percent of amount based on condition where “uber” is mentioned in Description field and place the value after calculating in the required field.

Amountcal.xlsx (8.8 KB)

Fine

Hope these steps would help you resolve this

—now use a excel application scope and pass the file path as input

—inside the scope use a READ RANGE activity and get the output with a variable of type datatable named dt

—now use a for each row loop and pass the above variable as input

—inside the loop use a assign activity like this

**row(4) = Convert.ToInt32(row(3).ToString)/100*10**

The use a write range activity and pass the above variable dt as input

Cheers @Rakesh_Tiwari

How convert percentage to a number after I build data table

To calculate percentage try to consider below

*Formula* C%*A=Answer

For Ex: C is 30 and A is 550

30% *550=Answer
step 1:First 30% is divided by 100
step 2: Then 30/100=0.3
step 3:Then multiply 0.3* 550=165

step 4:Hence proved - 165.

Otherwise try to use percentage calculator online

**Convert.ToInt32(row(3).ToString)/100*10**

Can you please explain how to apply this in add data row

Store the percentage value in a varaible and in add datatrow add in array format