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

expressions
(AEO Natore Sadar) #1

Help, help :slight_smile: 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) #2

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

(AEO Natore Sadar) #3

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

(AEO Natore Sadar) #4
(AEO Natore Sadar) #5
(AEO Natore Sadar) #6

still stuck!!

What shd do??

:frowning:

(AEO Natore Sadar) #7

Grade column is not virtual!!

(Aleksi Alkio) #8

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

(Aleksi Alkio) #9

Your Grade field is probably not a number field.

(Aleksi Alkio) #10

Sorry… decimal field.

(AEO Natore Sadar) #11

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

(Sarens Nass Middle East) #12

@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) #13

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 Middle East) #14

@Aleksi_Alkio Exactly… Thanks Translate

(AEO Natore Sadar) #15

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 Middle East) #16

@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