How to create a measure/expression to calculate the % increase/decrease between 2 figures

[Anonymous]

Hello,

Please can you help with the following;

I need to calculate the % increase/decrease between 2 figures.

Example

Total jobs for FY16          10

Total jobs for FY17          15

Percentage increase is     50%

Thanks,

Kizzy

[Anonymous]

Hi Staffan,

Please see results.  The top chart shows the figures using the % increase/decrease.  The bottom charts shows the actual figures that should be the basis for the % calculation.  As you can see the top box is incorrect.  Based on the top line Conn Car the % calc should be around 25% not 0.

Thanks,

Kizzy

[sunny_talwar · Accepted solution]

May be this

(Sum({$<[Requisition Status] = {Closed}, [Fiscal] = {'FY17'}>} [Approve to Close])/Sum({$<[Requisition Status] = {Closed},[Fiscal] = {'FY17'}>} [Number of Reqs]))/

(Sum({$<[Requisition Status] = {Closed}, [Fiscal] = {'FY16'}>} [Approve to Close])/Sum({$<[Requisition Status] = {Closed}, [Fiscal] = {'FY16'}>}[Number of Reqs])) - 1

[Anonymous]

IT WORKS!!!!

Many thanks for everyones quick replies

[sunny_talwar]

Awesome, please close the thread by marking the correct and helpful responses.

Best,

Sunny