Max contribution calculations based on age | Community
Skip to main content
Answered

Max contribution calculations based on age

C
Forum|alt.badge.img

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

 

Best answer by john.desborough

@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

 

View original

7 replies

john.desborough
Forum|alt.badge.img+6
  • john.desboroughCertified Partner
  • Certified Partner & Champion
  • 5328 replies
  • Answer
  • June 2, 2022

@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

 

If your third coffee of the day is not helping you with your Typeform, maybe we can help you find your answers...
Liz
Community Team
Forum|alt.badge.img+5
  • Liz
  • Tech Community Advocate
  • 15035 replies
  • June 10, 2022

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

Life is a series of awkward moments separated by snacks.
C
Forum|alt.badge.img
  • Cat88
  • Author
  • Explorer
  • 7 replies
  • June 13, 2022

Hi there,

Thanks a mil for your help, worked a charm!

Cat

Liz
john.desborough
Gabi Amaral
3 people like this
  • Liz
    Liz
  • john.desborough
    john.desborough
  • Gabi Amaral
    Gabi Amaral
Liz
Community Team
Forum|alt.badge.img+5
  • Liz
  • Tech Community Advocate
  • 15035 replies
  • June 13, 2022

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

Life is a series of awkward moments separated by snacks.
C
Forum|alt.badge.img
  • Cat88
  • Author
  • Explorer
  • 7 replies
  • July 18, 2022

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

Gabi Amaral
1 person likes this
  • Gabi Amaral
    Gabi Amaral
C
Forum|alt.badge.img
  • Cat88
  • Author
  • Explorer
  • 7 replies
  • July 18, 2022

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

Gabi Amaral
1 person likes this
  • Gabi Amaral
    Gabi Amaral
C
Forum|alt.badge.img
  • Cat88
  • Author
  • Explorer
  • 7 replies
  • July 18, 2022
Cat88 wrote:

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

Gabi Amaral
1 person likes this
  • Gabi Amaral
    Gabi Amaral

Reply


Still need help?

Don't be shy and ask the community.

Ask your question here!
Community T&Cs