Answered

help with a calculation

I need to calculate @price + @assets x % for three different tiers. Can this be done in a form or will I need to build it in Google Sheets?

Best answer by john.desborough

@bkcase - try this

create a variable for each of the three tiers, if needed, example v_sub1 and assuming that your x% is to the sum of the two variables and using 47% for the example
- add @price to v_sub1
- add @assets to v_sub1
- multiply v_sub1 by 47
- divide v)sub1 by 100

the last two logic rules are to give you the percentage since you can’t put in the decimal value directly

des

+6

@bkcase - try this

create a variable for each of the three tiers, if needed, example v_sub1 and assuming that your x% is to the sum of the two variables and using 47% for the example
- add @price to v_sub1
- add @assets to v_sub1
- multiply v_sub1 by 47
- divide v)sub1 by 100

the last two logic rules are to give you the percentage since you can’t put in the decimal value directly

des

If your third coffee of the day is not helping you with your Typeform, maybe we can help you find your answers...

+5

Hi @bkcase Hope you’re doing well! Were you able to utilize Des’s suggestions above?

Life is a series of awkward moments separated by snacks.

2 replies