Iterations in Excel

Help StudioX
1

Hi,
Can you please help me to do the below iterations in Excel using Studio X,

Need to use the below model in excel using the data set below (model is only a one line, each row should replace the previous row values),

Model
Attendance Salary Current Month Salary Payable
(A) (B) (A * B)

Data set
Name Attendance Salary
(A) (B) (C)
John 80% 100,000
Sarah 60% 60,000
Kevin 40% 50,000

The results should be written separately as follows,

Output
Name Current Month Salary Payable
John
Sarah
Kevin

Thank you in advance…

2

Hi ,
Can I use logic like :
salary=100,000
Attendance=80%
Salary payable= salary*attendance =80,000
So output like:
John 80,000

Is this correct logic.
If yes then let me know

3

Input:

image

Logic:

image

then

image

Attendance condition is: “convert.ToDouble(row(1).ToString)/100”

Salary Condition is: “convert.ToDouble(row(2).ToString)”

then

image

Output like:

image

4

Hi,

Many thanks for the reply. Actually this is what I want.

However, unfortunately as I’m using Studio X I do not have the “Assign” activity.

Thank you

5

Which version are you using? In 20.10 you have the save for later activity such as assing and also on group activities as cards you have the option to declare a variable

6

Hi,

I’m using 2020.10.2 community version.

If that is done through “Save for Later” can you please let me know the path.

Many thanks…