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!