community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Inflation Calculations

Highlighted
Meteoroid

I need to automate inflation calculations from Excel into Alteryx does anyone know how i might do this? 

 

Say if i have four data years of Inflation how would i allocate this into months and plug this into my Alteryx workflow/ 

Comet

Please post sample input and desired output

Meteoroid
I want it to look something like this

Annual Inflation

Financial Year

Monthly Inflation rate

% Monthly rate

0.026

2014/15

0.00214

0.21413%

0.034

2015/16

0.00279

0.27901%

0.029

2016/17

0.00239

0.23851%

0.036

2017/18

0.00295

0.29516%

0.525

2018/19

0.03579

3.57918%


Inflation

Apr-14

0.00214

May-14

0.00428

Jun-14

0.00642

Jul-14

0.00857

Aug-14

0.01071

Sep-14

0.01285

Oct-14

0.01499

Nov-14

0.01713

Dec-14

0.01927

Jan-15

0.02141

Feb-15

0.02355

Mar-15

0.02570

Apr-15

0.02849

May-15

0.03128

Jun-15

0.03407

Jul-15

0.03686

Aug-15

0.03965

Sep-15

0.04244

Oct-15

0.04523

Nov-15

0.04802

Dec-15

0.05081

Jan-16

0.05360

Feb-16

0.05639

Mar-16

0.05918

Apr-16

0.06156

May-16

0.06395

Jun-16

0.06633

Jul-16

0.06872

Aug-16

0.07110

Sep-16

0.07349

Oct-16

0.07587

Nov-16

0.07826

Dec-16

0.08064

Jan-17

0.08303

Feb-17

0.08541

Mar-17

0.08780

Apr-17

0.09075

May-17

0.09370

Jun-17

0.09665

Jul-17

0.09960

Aug-17

0.10256

Sep-17

0.10551

Oct-17

0.10846

Nov-17

0.11141

Dec-17

0.11436

Jan-18

0.11731

Feb-18

0.12027

Mar-18

0.12322

Apr-18

0.15901

May-18

0.19480

Jun-18

0.23059

Jul-18

0.26638

Aug-18

0.30218

Sep-18

0.33797

Oct-18

0.37376

Nov-18

0.40955

Dec-18

0.44534

Jan-19

0.48114

Feb-19

0.51693

Mar-19

0.55272



Nigel Applewhite



********************************************************************************************************************

This message may contain confidential information. If you are not the intended recipient please inform the
sender that you have received the message in error before deleting it.
Please do not disclose, copy or distribute information in this e-mail or take any action in relation to its contents. To do so is strictly prohibited and may be unlawful. Thank you for your co-operation.

NHSmail is the secure email and directory service available for all NHS staff in England and Scotland. NHSmail is approved for exchanging patient data and other sensitive information with NHSmail and other accredited email services.

For more information and to find out how you can switch, https://portal.nhs.net/help/joiningnhsmail
Pulsar

hi @NApplewh 

 

The data in your post came through as a single column, which makes it very difficult to map out.  Was it supposed to be a table?

 

Dan

Meteoroid

Yes it was meant to be a table

 

Pulsar

hi @NApplewh 

 

Can you post your sample data again, please.  the column breaks are not obvious

 

Dan

Labels