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)

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