Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Attached is my qvw file with sample date and requesting your help with an expression to create a list box with the following conditions.
If Total days = blank---->'Never loggedin'
If Fill Rate Admin >90% ----> 'High'
If Fill Rate Admin >=80% and <90%---> 'Medium'
If Fill Rate Admin <80%----> 'Low'
Appreciate your help.
Thanks,
Ram
Please use
=if([Total Days]='','Never loggedin',
if(replace([Fill Rate Admin],'%','')>90,'High',
if(replace([Fill Rate Admin],'%','')>=80 and replace([Fill Rate Admin],'%','')<90,'Medium',
if(replace([Fill Rate Admin],'%','')<80,'Low'))))
Hi Pratyush,
Thanks for your help.
But unfortunately, i see only 'Low' in my list box. i dont see other options available.
Thanks,
Ram
PFA the app.
I was about to offer up the same answer as Pratyush. His example works - I tested it with your file.