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.
I can say that most of the projects I have are complicated. And sometimes, it took me so much time to finish it, and still, sometimes, there might help me some mistakes. But I'm a student, and I need those mistakes to become better and improve my skills. But I have many other tasks, and sometimes it's problematical to do everything. But I will do my best, besides there are different services which may help you. I've been using this site https://supremestudy.com/ with different free essay examples for a long time, and those examples save me so much time. And I can dedicate that free time to my projects because that's something I like and want to connect my future with.
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
M1 replace into english
M2 '' '' maths
Thanks,
Jenefa
Sweet Potato Tec
All Answers
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))
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
Please share the screenshot ....
I will help you ....
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
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
M1 replace into english
M2 '' '' maths
Thanks,
Jenefa
Sweet Potato Tec
why we using ( ' ' ) this thing here? can u explain it..
Single quotes for whitespace between Failed subject
M1 M2 M3 or English Maths Science ---->like this
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...