Answered

Max contribution calculations based on age


Userlevel 1
Badge

Hi there,

I have input calculations and want the answer to show in a statement.

The calculation is based on age brackets e.g. Under 30, 30 to 39 etc.. 

So if you are age >30 & <39 jump to S3 and so on. 

I am asking for gross income and I have input variables based on the % max contributions 

e.g @under30 = 0.15 (15% of gross is the max for people aged under 30)

 

The statement will say 

Aged Under 30 you can get tax relief on 15% of your earnings every year

Based on your gross income you can contribute €xxx to your pension per month with full tax relief

 

How do I get the answer into the statement?

 

https://diarmuid974625.typeform.com/to/dkkpbF2k#u30result=xxxxx&thirtyto39result=xxxxx

 

icon

Best answer by john.desborough 2 June 2022, 14:54

View original

7 replies

Userlevel 7
Badge +6

@Cat88 - welcome to the community

create some variables ie v_LT30, v_LT39 etc and set them to the decimal value ie vor v_LT30 set the default to .15

create another variable called v_contribution default 0

then when someone inputs their income set a logic rule to do this calculation:

  • if income GT 0 add income to v_contribution

when someone picks their age bracket

  • if age is LT 30 then multiply v_contribution by v_LT30
  • if age is LT 39 then…..

that should do the trick

 

des

 

Userlevel 7
Badge +5

Happy Friday, @Cat88 ! Did Des’s solution work for you? 

Userlevel 1
Badge

Hi there,

Thanks a mil for your help, worked a charm!

Cat

Userlevel 7
Badge +5

Glad to hear, @Cat88 ! Thanks for letting us know!

Userlevel 1
Badge

Hi there @john.desborough @Liz 

 

I want to put a monthly figure onto S2. I’ve input ‘v_contribution / 12’ but it doesn’t seem to work. Any suggestions?

https://diarmuid974625.typeform.com/to/dkkpbF2k#u30result=xxxxx&thirtyto39result=xxxxx

Cat

Userlevel 1
Badge

Also on question 4 if you choose more than one option it will only follow one branch for follow up questions to the first option chosen and not ask the follow up questions that branch off the other options.

Is there a way around this?

Cat

Userlevel 1
Badge

Hi there @john.desborough @Liz 

 

I want to put a monthly figure onto S2. I’ve input ‘v_contribution / 12’ but it doesn’t seem to work. Any suggestions?

https://diarmuid974625.typeform.com/to/dkkpbF2k#u30result=xxxxx&thirtyto39result=xxxxx

Cat

There is also a cap on the amount if someone earns over 115k so I made a new variable 

  • v_over115 = 0
  • If ‘How much do you earn’ is greater than 115k then add 115k to v_over115
  • For q12 then I multiply v_over115 by the decimal variables depending on age

So will also want this divided to a monthly amount for S2

Reply