ShowAll Questionssorted byDate Posted
shalu

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

Sorna Jenefa
Hi,
I can't understand..
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

M1 replace into english
M2  ''            ''     maths

Thanks,
Jenefa
Sweet Potato Tec

Sorna Jenefa
Hi

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

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

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 Jenefa
Hi,

Sorna Jenefa
OK

Sorna Jenefa
Hi

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
shalu
how to create it?..
Sorna Jenefa
Hi,
I can't understand..
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

M1 replace into english
M2  ''            ''     maths

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

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

Sorna Jenefa
Hi,

Single quotes for whitespace between Failed subject

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

shalu
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...
shalu
can anyone explain this thing....