N
nxqviet
I have a list of Variance Percentages that ranges from -35%, to 25%, I
want to assign a Grade to this value using a query and write in the a
Switch Expression.
It Looks like this:
Switch([VarianceP]<-35,"F",[VarianceP]<-30,"D-",[VarianceP]<-25,"D",[VarianceP]<-20,"D+",[VarianceP]<-15,"C-",[VarianceP]<-10,"C",[VarianceP]<-5,"C+",[VarianceP]<-0,"B-",[VarianceP]<5,"B",[VarianceP]<10,"B+",[VarianceP]<15,"A-",[VarianceP]<20,"A",True,"A+")
This function will not evaluate any Negative value, thus, all Variance
that is below 0 will have a Grade of B-. Anyone have an idea of how to
fix this problem and force the function to evaluate all values?
Thanks for your time and assistance,
V_
want to assign a Grade to this value using a query and write in the a
Switch Expression.
It Looks like this:
Switch([VarianceP]<-35,"F",[VarianceP]<-30,"D-",[VarianceP]<-25,"D",[VarianceP]<-20,"D+",[VarianceP]<-15,"C-",[VarianceP]<-10,"C",[VarianceP]<-5,"C+",[VarianceP]<-0,"B-",[VarianceP]<5,"B",[VarianceP]<10,"B+",[VarianceP]<15,"A-",[VarianceP]<20,"A",True,"A+")
This function will not evaluate any Negative value, thus, all Variance
that is below 0 will have a Grade of B-. Anyone have an idea of how to
fix this problem and force the function to evaluate all values?
Thanks for your time and assistance,
V_