Answered

Advanced calculations?

  • 22 October 2021
  • 8 replies
  • 110 views

Hi,

Im trying to solve this but no luck.

 

This is what I want:

 

User chooses material from picture choice ie:

Q1: choose stone color.

Answer gives: 

add: Silestone_pricegroup6 to sqm_price

 

Q2: what is the length of your worktop?

User input adds to total_length 

 

Q3: what is the width of you worktop?

User input adds to total_width 

 

Q4: how long do you want your splashguard?

User input adds to total_length 

 

Q5: How high do you want your splashguard?

User input adds to total_width

 

Calculation 1:

total_length is devided by 1000

total_width is devided by 1000

total_length * total_width= total_sqm

total_sqm * sqm_price= sum_sqm_price

 

Thanks!

 

 

 

 

 

icon

Best answer by nvifred 22 October 2021, 20:48

View original

8 replies

Userlevel 7
Badge +5

Hi @nvifred Happy Friday! Could you send some screenshots of how you have this setup so we can take a closer look at what’s in your form? Thanks!

 

Hi, I’ve tried different setups but without success. this is the latest one.

if it helps :)

 

Userlevel 7
Badge +5

Hm, I think it might have something to do with the ‘always’ portion, but I’m not totally sure. @john.desborough do you have any experience stacking multiple calculations like this? :nerd:

I think I Solved it with IF statements.

Userlevel 7
Badge +5

Oh! Glad to hear, @nvifred ! Do you mind sharing any screenshots of how you set them up? I still need to get better at jumps too! 😂

Userlevel 7
Badge +6

@nvifred @Liz - sorry for the delay in finding my way in here to try and answer but it appears that i am too late to be of value lol.. 

but the IF statements should be able to do that, along with a variable or two perhaps.. please post an update if you have any other questions or choose to share your screenshots as @Liz suggested

 

cheers

des

Reply