# How to apply IIF condition on Grouped total in SSRS Report

**URL:** <https://www.dynamicsuser.net/t/how-to-apply-iif-condition-on-grouped-total-in-ssrs-report/68672>\
**Category:** Technical Forum\
**Created:** [May 31, 2021, 8:17pm UTC](https://www.dynamicsuser.net/t/how-to-apply-iif-condition-on-grouped-total-in-ssrs-report/68672 "2021-05-31T20:17:12Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![RahulSaklani](https://avatars.discourse-cdn.com/v4/letter/r/4bbf92/32.png) [@RahulSaklani](https://www.dynamicsuser.net/u/RahulSaklani)\
**Post date:** [May 31, 2021, 8:17pm UTC](https://www.dynamicsuser.net/t/how-to-apply-iif-condition-on-grouped-total-in-ssrs-report/68672/1 "2021-05-31T20:17:12Z")

</div>

Hi All,

I have one condition where Dr. & Cr. are settling the voucher where as the unsettled transaction have either Dr. or Cr. amount only.

I have created a SSRS report where I grouped Voucher and getting total as zero for every grouped voucher.

Now i have to assign a Status field in Report design where i need to pass ,0 = Posted else Open. Now when i am taking one group total it’s going to the grand total of the report and open value is appearing for all.