I've created a report table and instead of the total column adding up the values in the specific columns it's completing the calculation of the columns:

An example of the columns are as per below:

Resource Rate      Resource Hours      Resource Cost

      £100                           28                        £2,800

      £150                           32                        £4,800

      £190                           17                        £3,230

I would expect the totals to be:

Resource Rate: £440

Resource Hours: 77

Resource Cost: £10,830

Instead the Resource Cost is showing as £33,880 - Total Resource Rate x Resource Hours - how can I swap the totals values to show what I'm expecting?

Are you applying the formula for the resource cost in the back end table or in the reporting table?  I think if you apply it on the reporting layer, you will run into this issue, but if it's in the back end table, you won't. 

In the past, I've had to create a duplicate field in the back end table so that one field with resource rate was numeric and the other was a label.  I could use the number field to calculate such things as resource cost, but I would use the label field in the reporting table so that it wouldn't show up in the sum.  Average resource rates are more valuable than summed resource rates.

The formula is on the reporting table, will try to do the work on the dataset and see if that works for me. Thanks Nancy

Ha, Nancy - we ran into that just recently - it looks funny to have resource counts in a report over to the left (label), but we had to do it that way because regardless of how we'd set them up - label, not summable, not number, etc., etc., it would always appear in the total column - ugh

Hi Julie,

This looks to be a bug that I've also reproduced, and raised a support ticket for. Can you also raise a support at support.apptio.com

Michael

Thanks Michael, will raise the ticket now

Support rectified the issue - they edited the two cost columns by making them numeric and summable - the issue is now solved. Thanks @Michael Moulsdale for your help

Hi July, yes I just fell onto that as well. Sorry, should have caught that first time round