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?

icon

Best answer by john.desborough 26 April 2024, 20:44

Userlevel 7

+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

Userlevel 7

+5

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

Sign up