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?
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.
Question
pgjacob
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
Link to comment
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.