summing up an if statement with integrated aggregate function like sum and min

[thanhphongle]

Hello Community,

this is my table

category	use_term	payment	markup
Notebook	3	10	2%
Notebook	12	10	1%

I created a variable called v_term_extension = 36

in this use case I would like to calculate:

sum(if( v_term_extension <= use_term,  use_term * payment * markup,

if( v_term_extension > use_term, (use_term * payment) +

(v_term_extension - sum (use_term)) * payment * (min(markup) = 1%)

)))

The result should be

category	calculation	result
Notebook	3 * 10 * 2%	0,6
Notebook	12 * 10 * 1%	1,2
Notebook	(36 - (12 + 3)) * 10 * 1 %	2,1

is this possible to do this in QV?