Calculate Percentage

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)

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 :thinking:

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
step 4:Hence proved - 165.
Otherwise try to use percentage calculator online

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