Forum Discussion

FarhanBAE's avatar
FarhanBAE
New Member
4 years ago
Solved

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...
General Comment
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    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.

     

v-chenwuz-msft's avatar
v-chenwuz-msft
Icon for Community Support rankCommunity Support
4 years ago

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.