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 |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |