I have two entities result and student. In result entity i have 2 fields "score"(Integer) and "resultStatus"(Enum). resultStatus has 2 values "Passed" and "Failed".
I want to get the sum of "Passed" values in student entity.
I have applied the formula below and it works fine but fetches the sum of all the passed/failed status. How can i get the sum of "passed" status. (that is sum of columns when resultStatus="Passed").
this is the formula i have applied . totalScoreAchieved=entity\sumRelated('results', 'score','student'); Please help me to resolve the issue .
I want to get the sum of "Passed" values in student entity.
I have applied the formula below and it works fine but fetches the sum of all the passed/failed status. How can i get the sum of "passed" status. (that is sum of columns when resultStatus="Passed").
this is the formula i have applied . totalScoreAchieved=entity\sumRelated('results', 'score','student'); Please help me to resolve the issue .
Comment