HOTFIX: If you are running SBM 11.4.1, check out this hotfix! Fixes include: repository gives error 500, Exchange w… https://t.co/ncbIJWcPtU
So we are having a field called estimated time in days and a field time used to resolve the issue in days (both using a floating point value).
Is there a way to create a report that sums up both values from ALL ITEMS within a project resulting in the following result?
like: RESULT = SUM(estimated time in days) - SUM(time used to resolve the issue in days)
Thanks in advance!
Accepted AnswerDavid SheaffeOffline0I don't think there is a report style that will give you what you need. A listing report can have a calculated column on the 2 fields for each individual item - but doesn't give a total for all items. A Summary report style will give you a SUM for the individual fields, but not a calculation between the 2 fields.
Perhaps someone may have an alternative that might work for you.
I stuck some notes into the attached file. One difference is that you are looking for a difference calculation between 2 sums. My version didn't do that -- it just displayed sums for columns. I put the result of the difference calculation in column 0 of the report. Not the best place, but good enough for a demo.
I also attached a PNG with a screen shot showing what it looks like.
Accepted AnswerJoshua NotheisenOffline