Hi,
I want to change the calculation a little bit :
[Price]+ (abs([Size] > 30) * ((([Size]-30)/5) + 6)) + (abs([Size] <= 30) * ((([Size]-15)/5)*2))
I want also the price decrease 1 euro if size is 10 cm.
10 cm = 5,00 (-1,00)
15 cm = 6,00 (= 6,00)
20 cm = 8,00 (+2,00)
25 cm = 10,00 (+4,00)
30 cm = 12,00 (+6,00)
35 cm = 13,00 (+7,00)
40 cm = 14,00 (+8,00)
45 cm = 15,00 (+9,00)
I tried a lot of combinations for the calculation, but non of them works.
([Price]+ (abs([Size] = 10) * (([Size]-15)/5)) + (abs([Size] <= 30) * ((([Size]-15)/5)*2)) + (abs([Size] > 30) * ((([Size]-30)/5) + 6))))
Can you give it a try ?
Geert.