Help, help What will be the app formula for โGradeโ calculation?
If responded result is 4 then grade will b โAโ, for 3to3.99, โBโ, for 2to2.99,C, below these D!!
What will b the expression??
SWITCH(FLOOR([Grade]),4,โAโ,3,โBโ,2,โCโ,โDโ)
โFLOOR has invalid inputโ showing? Why? What to do
still stuck!!
What shd do??
Grade column is not virtual!!
SWITCH(FLOOR([Total Score]),4,โAโ,3,โBโ,2,โCโ,โDโ)
Your Grade field is probably not a number field.
Sorryโฆ decimal field.
So, i need to change the grade column type to decimal, then try itโฆ Still not working, why?
@AEO_Natore_Sadar Why Grade column should be in decimal field? It Supposed to be text field since you will store A B C or D.
The source need to be a decimal because he is filling the value as desimal, not the column where this letter will be stored.
@Aleksi_Alkio Exactlyโฆ Thanks Translate
But my score field is decimal, thats how i get 3.55 or something like that. But not working, guess i miss somethingโฆ Pls tell me what to do?
@AEO_Natore_Sadar If Grade column is virual then all existing records will be calculated. If it is normal field the new records only get effect. Otherwise you have edit and save all existing records
User | Count |
---|---|
40 | |
36 | |
34 | |
23 | |
17 |