0
Hello,

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!
Responses (5)
  • Accepted Answer

    Wednesday, July 04 2018, 05:38 PM - #Permalink
    0
    I 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.
    The reply is currently minimized Show
  • Accepted Answer

    Monday, July 16 2018, 02:41 AM - #Permalink
    0
    Brian:
    I don't know what's going on ... Please delete the dups ...
    The reply is currently minimized Show
  • Accepted Answer

    Monday, July 16 2018, 02:41 AM - #Permalink
    0
    Brian:
    I don't know what's going on ... Please delete the dups ...
    The reply is currently minimized Show
  • Accepted Answer

    Monday, July 16 2018, 02:44 AM - #Permalink
    0
    I had some older JavaScript that did something similar. I tried to hack together a demo. It seems to work however, depending on version, your mileage may vary.

    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 attached the JavaScript file with a PDF extension. It really isn't PDF -- It's text. SerenaCentral get's weird with attached files it doesn't like.

    I also attached a PNG with a screen shot showing what it looks like.
    The reply is currently minimized Show
  • Accepted Answer

    Thursday, August 09 2018, 05:56 AM - #Permalink
    0
    Sorry for the late reply, i missed it somehow. Thanks for the great answer though, it helped a lot!!
    The reply is currently minimized Show
Your Reply

Recent Tweets

RT @TrainingsEdu: Potřebujete získat znalosti o produktu Micro Focus UCMDB, porozumět základním pojmům a aplikacím? Na kurzu Universal CMDB…

by Micro Focus Support