Skip to Content
0
Former Member
Jan 07, 2011 at 01:05 PM

Calculated quantity evolution in Query Designer

50 Views

Hello,

I have a few short questions regarding ways of calculating a quantity evolution key figure in Query Designer:

I have a sales figure, let's say an order quantity. I'd like to have it's evolution calculated and displayed (based on another variable with a time period selection) next to it.

- Is there any other way of entering the following formula for the calculation then: (figure A - figure A(N-1)) / figure A (N-1) * 100 ?

- I would like to have a positive sign when this calculated evolution is positive as well as the percentage symbol next to it (eg: +15%). Is there a way to do this?

- Is there a way to automatically fill the time period selection for the variable (using for example a current week - 1)?

Thanks for your proposals.

Best regards,

Olivier