Calculation of the Avg of the row

Help
1

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
2

Hi @naveen.dsn,

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

Thanks and regards.

3

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

1 Like
4

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)
5

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
6

Why is outdt an Object?

7

image
image1366×768 101 KB

8

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

9

Got it.
capt
I think you should add .ToString

10

image
image1366×768 106 KB

11

i tried still getting error.

12

Use Write Cell instead of Write Range :slight_smile:

4 Likes
13

Thank You

1 Like
14

You’re welcome!

15

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