Forum Discussion
Report builder SSRS - calculated field based on other field and condition
As image above I need to sum the total with conditions
-Student has more then subjects
-every subject has 2 or 3 quizzes and final and re- test ( re-test :if the student get less then 60 from The final
the total final if the Subject has 2 quizzes = 15% from Q1 + 15% from Q1 +70% from final or from re-test
the total final if the Subject has 3 quizzes = 10% from Q1 + 10% from Q1 + 10% from Q3 +70% from final or from re-test
Notice: only one subject has 3 quizzes
Hi FarhanBAE ,
Maybe you can try code like this:
=IIF(IsNothing(Fields!Q3Value),
Fields!Q1.Value*0.15+Fields!Q2.Value*0.15+Fields!Final.Value*0.70,
Fields!Q1.Value*0.10+Fields!Q2.Value*0.10+Fields!Q3.Value*0.10+Fields!Final.Value*0.70)Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
- v-chenwuz-msft
Community Support
Hi FarhanBAE ,
Maybe you can try code like this:
=IIF(IsNothing(Fields!Q3Value),
Fields!Q1.Value*0.15+Fields!Q2.Value*0.15+Fields!Final.Value*0.70,
Fields!Q1.Value*0.10+Fields!Q2.Value*0.10+Fields!Q3.Value*0.10+Fields!Final.Value*0.70)Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.