Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Variance value not displaying on all rows in table


I've just installed the time reports plugin and set one up. Only issue is the value for variance isnt appearing on every row, only for minus figures its seems (see screenshot attached). 


Can you help? 



2 answers

E.g on row 4 - the estimate is 3 hours and 2 hours were spent, which leaves 1 hour. The variance should therefore, display as 1 hour, but it's blank. 


You can see it working fine on the plugin demo page

Hi Jack,

It does show positive variance too in your example on the first row. It just does not show 0 variance.

Thank you

Hi Andriy

Many thanks for getting back to me. Ok what do you think is causing the blank fields on the rest of the rows? 

Hi Jack,

Zero value, i.e. no variance, estimate or time spent, is displayed with empty - blank field.

Thank you.

But if you refer to my original example...


E.g on row 4 - the estimate is 3 hours and 2 hours were spent, which leaves 1 hour. The variance should therefore, display as 1 hour? 

Hi Andriy 

Many thanks for the article. I have read it and note it states the following...

Variance. Is Original Estimation - Estimated Time Remaining.


Which makes sense but I guess it's not what I'm after. Surely the point of variance is to calculate the overall difference in time, whether positive or negative.

To flip it round the other way. I'm looking for a simple way of budget management by displaying all of the tasks in a table and see what has overran and also any time left on other tasks, and see the overall balance.

This formula would therefore be...

Is Original Estimation - Time Spent

Is this possible? 

Hi Jack,

I think it can be achieved by setting Remaining Estimate to 0, when needed. May be  it is done when issue is resolved, or I can make add-on ignore Remaining Estimate if issue is resolved.

Pleaset let me know.

Great thanks for pointing that out. When you refer to 'resolved', is this a status?

In our Kanban we have other status's set such as 'work in progress' or 'done'. 

Your suggestion sounds great and for it to work, do we just set up a new status called 'resolved' for the done column?

I'm referring to Resolution field, see for example.

Note, you may want to clear Remaining Estimate in similar way instead.

Thanks very much. I have spoken with my colleague who says she will be able to set up an auto setting of the original estimate figure to 0 when a task is dragged into the done column. 

Thanks very much for your help Andriy. I may be in touch again with another query soon. 

Have a good day

Great, thank you!

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Marketplace Apps & Integrations

Learn how to request and manage app requests in the Marketplace

G’day everyone! Super exciting news coming from the Marketplace. We have now fully rolled out the ability for end-users to submit app requests to admins directly from within the product! No longer ...

62 views 1 7
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you