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

thanhphongle — Fri, 10 Nov 2017 15:50:00 GMT

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

is this possible to do this in QV?

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