Calculation of the Avg of the row

Hi all.,

can anyone suggest to place the Avg calculated of the row, to place at the end of the same row.

i have calculated the avg of the perticular row , i can place it by using the write range at the end of that row.

but every the row values and no. will vary.

i need a support on this.

1 Like

Hi @naveen.dsn,

There are multiple solutions on this one.
Can you share with us the workflow that you created?

Thanks and regards.

Avgcalculation.xaml (6.6 KB)
month output data.xlsx (9.4 KB)

1 Like

You can use this instruction:

  1. Loop per Row (create a counter variable to track what row number you are already.
  2. Calculate the average.
  3. Use Write Range activity (use: > “H” + counter < as the Range)

Hi .,

i implemented it but im getting a error.

im uploading the XAML file and Data error.

Can u pl suggestAvgcalculation.xaml (7.5 KB)
month output data.xlsx (9.4 KB)

1 Like

Why is outdt an Object?

output of the avg is Object. I used direct avg activity. and im getting the correct value.

Got it.
I think you should add .ToString

i tried still getting error.

Use Write Cell instead of Write Range :slight_smile:


Thank You

1 Like

You’re welcome!

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