Hi all,
I have two questions here:
1.How do i convert Yes/No type to 1 and 0 so i can total it up?
2.How to set a column that is enum text, e.g A,B,C based on total up of other column?
Thanks.This community is so good!!!
)
But Iโm assuming youโre totaling up the whole column, but looking now maybe youโre just totaling up a bunch of columns in a single record?
Yes. it is for a single record.Thanks
How about my second question? Let say i have two colums, one TotalMark one is Grade.
If want the Grade value depent on TotalMark, e,g TotalMark>85 Grade=A
Okโฆit works like a charm!!! Thanks
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |