Help, help :) What will be the app formula fo...

[AEO_Natore_Sada]

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

[Aleksi_Alkio]

SWITCH(FLOOR([Grade]),4,“A”,3,“B”,2,“C”,“D”)

[AEO_Natore_Sada]

“FLOOR has invalid input” showing? Why? What to do

[AEO_Natore_Sada]

still stuck!!

What shd do??

[AEO_Natore_Sada]

Grade column is not virtual!!

[Aleksi_Alkio]

SWITCH(FLOOR([Total Score]),4,“A”,3,“B”,2,“C”,“D”)

[Aleksi_Alkio]

Your Grade field is probably not a number field.

[Aleksi_Alkio]

Sorry… decimal field.

[AEO_Natore_Sada]

So, i need to change the grade column type to decimal, then try it… Still not working, why?

[Sarens_Nass_Mid]

@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.

[Aleksi_Alkio]

The source need to be a decimal because he is filling the value as desimal, not the column where this letter will be stored.

[Sarens_Nass_Mid]

@Aleksi_Alkio Exactly… Thanks Translate

[AEO_Natore_Sada]

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?

[Sarens_Nass_Mid]

@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