# How it calculates total row?

**URL:** <https://community.eazybi.com/t/how-it-calculates-total-row/2767>\
**Category:** Questions & Answers\
**Tags:** jira\
**Created:** [September 5, 2019, 10:27am UTC](https://community.eazybi.com/t/how-it-calculates-total-row/2767 "2019-09-05T10:27:33Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sergi](https://community.eazybi.com/user_avatar/community.eazybi.com/sergi/32/10057_2.png) [@Sergi](https://community.eazybi.com/u/Sergi)\
**Post date:** [September 5, 2019, 10:27am UTC](https://community.eazybi.com/t/how-it-calculates-total-row/2767/1 "2019-09-05T10:27:33Z")

</div>

Hi,

I’m new using eazyBI and this is one of my tests to learn about it.  
I hope can you help me.

When I select to calculate total row automatically seems that will be different for “Calculate remaining estimate” but show “remaining estimate hours” same result.

 ![imagen](https://community.eazybi.com/uploads/default/original/2X/7/76c98eeaf3f2fcfd1ef43ca3c0a0387115dcbe7f.png)

This is the defined measure:

 ![2019-09-05%2012_21_35-Window](https://community.eazybi.com/uploads/default/original/2X/e/efd38bb158b739d3dc9efe2f8b66934f62458404.png)

Can you explain how works the total row calculate in this case?

Best Regards,  
Sergi Macià

---

<div class="post-metadata">

**Author:** ![daina.tupule](https://community.eazybi.com/user_avatar/community.eazybi.com/daina.tupule/32/8838_2.png) [@daina.tupule](https://community.eazybi.com/u/daina.tupule)\
**Post date:** [September 17, 2019, 10:53am UTC](https://community.eazybi.com/t/how-it-calculates-total-row/2767/2 "2019-09-17T10:53:29Z")

</div>

The formula uses Issue property **Issue status** that works on individual issues only.

eazyBI uses an optimization for **total** calculation. It executes the same formula on totaling row independently from the report results. The validation for **issue status = Done** fails for totaling row, and it picks up remaining estimated hours as the status is empty (not Done) for totaling row.

I updated the formula, to get it working on issues only. It will check if there is any value in status at all and only then look for a particular status value. This will force to sum up value in columns for total calculation.

```
CASE WHEN
not isempty([Measures].[Issue status])
THEN
IIF([Measures].[Issue status]='Done',
0-[Measures].[excess hours / hours left over],
[Measures].[Remaining estimated hours])
END

```

Daina / [support@eazybi.com](mailto:support@eazybi.com)