Jump to content
  • 0

Aggregates in table report


Question

Hi All

I am trying to sum AND add a percentage to two separate columns in a tabular report.  I can do this fine with two separate aggregates:

SUM(cost_2017)*1.1 = aggregate 1

SUM(cost_2018)*1.1 = aggregate 2

 

But the results fall in two different rows for each aggregate.  How do I just do one aggregate, but for column 2017 costs, use the cost_2017 number and for column 2018 costs, use the cost_2018 numbers for the column 2018 costs and they fall in the same row.  I can select both the cost 2017 and cost 2018 numbers in the selected fields, but can only do a formula for EITHER of them... Doing a SUM this way works (I can pull over 2017 and 2018 costs, and get two different sums in one row), but this doesn't seem possible for formulae?

Thanks in advance

melissa

 

Example attached

aggregate.PNG

Link to post
Share on other sites

1 answer to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...