+ Start a Discussion
shalushalu 

create an object as students course,marks field 6 subject,if score as below 35 means ,grade= should should be 'F' or if above 35 means grade= should be 'A',and then failed subject = should count how subject as failed in (text)...using formula field.

Best Answer chosen by shalu
Sorna JenefaSorna Jenefa
Hi,
I can't understand..
What did u ask...
But i think you ask like this...

IF( M1__c >=35,'',' M1')  + IF(M2__c >=35 ,'',' M2')   +IF(M3__c >=35,'',' M3') +IF(M4__c >=35,'',' M4') +IF(M5__c >=35,'',' M5')+ IF(M6__c >=35,'',' M6')
M1__c ----->Subject fields

User-added image

M1 replace into english
M2  ''            ''     maths


Thanks,
Jenefa
Sweet Potato Tec

All Answers

Sorna JenefaSorna Jenefa
Hi

6 --->Marks field  ------->Number(m1...m6)

Grade field :

Data Type Formula  (Text)

IF( M1__c >35 && M2__c >35 && M3__c >35 && M4__c >35 && M5__c >35 && M6__c >35, 'A', 'F')

Count field for failed subject :

Formula Number field:

IF( M1__c >=35,0,1) + IF(M2__c >=35 ,0,1) + IF(M3__c >=35,0,1) +IF(M4__c >=35,0,1) +IF(M5__c >=35,0,1)+IF(M6__c >=35,0,1)

Formula Text field:

TEXT(IF( M1__c >=35,0,1) + IF(M2__c >=35 ,0,1) +IF(M3__c >=35,0,1) +IF(M4__c >=35,0,1) +IF(M5__c >=35,0,1)+ IF(M6__c >=35,0,1))

User-added image

Let me know if its works as you excepted.

Please mark it as solved so that it will be helpful to others

Thanks,
Jenefa
Sweet Potato Tec


 
Sorna JenefaSorna Jenefa
Hi,

Please share the screenshot ....
I will help you ....
Sorna JenefaSorna Jenefa
OK
 
Sorna JenefaSorna Jenefa
Hi

Please Now try this


IF( M1__c >=35,'','M1') + IF(M2__c >=35 ,'','M2') +IF(M3__c >=35,'','M3') +IF(M4__c >=35,'','M4') +IF(M5__c >=35,'','M5')+ IF(M6__c >=35,'','M6')

Thanks,
Jenefa
Sweet Potato Tec
shalushalu
how to create it?..
Sorna JenefaSorna Jenefa
Hi,
I can't understand..
What did u ask...
But i think you ask like this...

IF( M1__c >=35,'',' M1')  + IF(M2__c >=35 ,'',' M2')   +IF(M3__c >=35,'',' M3') +IF(M4__c >=35,'',' M4') +IF(M5__c >=35,'',' M5')+ IF(M6__c >=35,'',' M6')
M1__c ----->Subject fields

User-added image

M1 replace into english
M2  ''            ''     maths


Thanks,
Jenefa
Sweet Potato Tec
This was selected as the best answer
shalushalu
IF( M1__c >=35,     ''      ,  'M1')

why we using   (   '  '  ) this thing here? can u explain it..


 
Sorna JenefaSorna Jenefa
Hi,

Single quotes for whitespace between Failed subject

M1 M2 M3 or  English Maths Science  ---->like this

 
shalushalu
hi ,
        how to create an rating for marks (like A++,A,B,B++,C,D,F)total marks should be count and grade use like that...
shalushalu
can anyone explain this thing....