Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi to all!
I have the following table
ID | D.1 | D.2 | D.3 | D.4 | D.5 | D.6 | D.7 | D.8 | D.9 | D.10 | D.11 | D.12 | D.13 | D.14 | D.15 | D.16 | D.17 | D.18 | D.19 | D.20 | D.21 | D.22 | D.23 | D.24 | D.25 | D.26 | D.27 | D.28 | D.29 | D.30 | D.31 |
AAAA | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2.31 | 0 | 0 | 0 | 0 | 0 |
BBBB | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
CCCC | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
DDDD | 9.50 | 14 F | 0 | 0 | 8.05 | 8.00 | 7.21 | 9.33 | 7.18 | 0 | 0 | 0 | 0 | 8.02 | 7.59 | 8.28 | 0 | 0 | 8.07 | 8.09 | 9.03 | 8.17 | 9.31 | 0 | 0 | 6.59 | 14 F | 9.20 | 0 | 0 | 0 |
Where i have for D.1 = DAY 1st of the month the worked hours per ID, and so on for the following days.
In some cases i have something like 14F or other alphanumerical code wich represents the reason for a day off.
I need to sum per MONTH the worked hours for each ID, and mark that days where someone takes a day off.
Thanks!
What is the expected output for the data you have provided?
Hi Sunny T, i need a table with ID, MONTH, Sum(Hours), Count(Days with alphanumeric codes).
The Information in the example is for one month but i have the same table for each month of the year so i need something like this
ID | Month | worked Hrs | Non Worked days |
AAA | March 18 | 80 | 0 |
BBB | March 18 | 60 | 2 |
CCC | March 18 | 20 | 15 |
Thanks!
ID = CCC has all 0, how did you get worked Hrs = 20 AND Non Worked days = 15?
I tried to make an example with a resultant table, i need to separate the Hours values (4.25,8.5,7.0, etc) to (14F, 9B2, etc) and count or sum in that way.
Thanks!
May be like this
Count(If(IsNum(Value), Value))
or
Count({<Value = {"=IsNum(Value)"}>}Value)