cancel
Showing results for 
Search instead for 
Did you mean: 

Calculating difference between Amounts for 2 quarters

Former Member
0 Kudos

HI All,

I have a bunch of queries which have 2 quarters as columns which the user can enter.there is no offset involved.

The total amounts are being displayed for each of the 2 quarter selected. I need to calculate the difference in the 2 amounts for the quarters.

Any suggestions are welcome.

Thanks in Advance.

Ashish.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

You can simply create a Formula in your structure by right clicking on the structure, then choose New Formula. Double click on your first column, then click on '-' then double click on second column.

That's all. If you need it more often, right click on the structure, then say Save... Your structure is saved and you can access it in any query of your InfoProv by dragging it from the left field (it's right on top).

Best regards

Dirk

Former Member
0 Kudos

Hi Dirk,

appreciate your response.

My problem is that I have only one key figure which will be displayed for each quarter.

Quarter 1 Quarter 2 Difference Q2-Q1

200 300 100

How will this be possible when the Quarters are entered by user and they need not be continuous.

Thanks in Advance.

Ashish.

Former Member
0 Kudos

Hi Ashish,

in this case I would recommend that you create 2 structures in your query. The first one hold your key figure and the second one holds some selections and formulas. One selection is the 1st quarter, another selection is the 2nd quarter (may be a offset of the first one) plus may be some other selections. One formula is selection1 - selection2 or vice versa plus some other formulas. This will work.

regards

Siggi

Former Member
0 Kudos

Query 0SD_C03_Q0019 of infocube 0SD_C03 from the Business Content can be used as a good example.

Success!

Former Member
0 Kudos

Hi Ashish,

I think, what you need is two restricted keyfigures (the amount restricted to the entered quarters) and then, additionally a calculated keyfigure out of your restricted keyfigures.

regards

Siggi