Hello,
I have a list of Products and to each one I have listed how many backups in each level is available.
I want to be able to assign three categories to each product based on how many backups in each level we have. Categories should be assigned based on below key:
If sum Backup Now 1+Backup Now 2+Backup Now 3+Backup Now 4 >=3, 'G',
if sum Backup Now 1+Backup Now 2+Backup Now 3+Backup Now 4 =2 and sum Backup 2 Months 1+Backup 2 Months 2+Backup 2 Months 3+Backup 2 Months 4>=1, 'G',
if sum Backup Now 1+Backup Now 2+Backup Now 3+Backup Now 4 =2 and sum Backup 2 Months 1+Backup 2 Months 2+Backup 2 Months 3+Backup 2 Months =0, 'Y',
if sum Backup Now 1+Backup Now 2+Backup Now 3+Backup Now 4 =1 and sum Backup 2 Months 1+Backup 2 Months 2+Backup 2 Months 3+Backup 2 Months =1, 'Y', else 'R'
Is there a way to create calculated column based on this criteria in script? I have tried by using if and then group by Product ID but it is not working for me... Any help will be much appreciated!
This is sample data:
| Product ID |
Backup Now 1 |
Backup Now 2 |
Backup Now 3 |
Backup Now 4 |
Backup 2 Months 1 |
Backup 2 Months 2 |
Backup 2 Months 3 |
Backup 2 Months 4 |
Backup 6 Months 1 |
Backup 6 Months 2 |
Backup 6 Months 3 |
Backup 6 Months 4 |
| P000000001 |
P067 |
|
|
|
|
|
|
|
P30 |
|
|
|
| P000000002 |
P067 |
|
|
|
P70 |
|
|
|
P30 |
|
|
|
| P000000003 |
|
|
|
|
P70 |
|
|
|
|
|
|
|
| P000000004 |
P067 |
|
|
|
P70 |
P56 |
|
|
|
|
|
|
| P000000005 |
|
|
|
|
|
|
|
|
|
|
|
|
| P000000006 |
P067 |
|
|
|
P70 |
P56 |
|
|
|
|
|
|
| P000000007 |
P067 |
P089 |
|
|
P70 |
|
|
|
|
|
|
|
| P000000008 |
P067 |
|
|
|
P70 |
|
|
|
|
|
|
|
| P000000009 |
P067 |
|
|
|
P70 |
|
|
|
|
|
|
|
| P000000010 |
P067 |
P089 |
|
|
P70 |
|
|
|
|
|
|
|
