i am using switch statement on report to define a criteria. Here is the switch statemtn code i am using
now i want to count how many of the data is A+ or in B's or in C's etc. what should i do to achieve the result like this
A's = 5
B's = 3
C's = 11 etc etc
Code:
=Switch([smttl]/[smmttl]*100>90,"A+",[smttl]/[smmttl]*100>=80,"A",[smttl]/[smmttl]*100>=70,"B+",[smttl]/[smmttl]*100>=60,"B",[smttl]/[smmttl]*100>=50,"C",[smttl]/[smmttl]*100>=40,"D",True,"F")
now i want to count how many of the data is A+ or in B's or in C's etc. what should i do to achieve the result like this
A's = 5
B's = 3
C's = 11 etc etc