Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need to calculate one column with the below conditions using nested if statements in script.
Kindly help me on creating the below condition in script.
Start Date = '2018-10-01'
Format = (year,month,date)
With value >=50 'A Category'
With value >=20 and <50 'B Category'
With value >0 and <20 'C Category'
With Value = 0 in Current 12 Months but have non zero values since Start date 'D Category'
With Value = 0 Since Start date 'E Category'
as column name
Kindly help me in calculating the above column.
Best Regards,
Siva
Hi All,
Can someone help me on achieving the above column
Best Regards,
Siva