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??

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??

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.

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