function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ 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....
Chris Glover 7Chris Glover 7
Sounds like a complicated project
Chris Glover 7Chris Glover 7
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.