Meaning of the formula?

[qlikviewwizard]

what is the meaning of the formula?

=if(DEPTNO=30,sum({$<EMPNO =  {"=(Sum([COMM])/Sum([SAL])) <=10"} >} [MINSAL]*BONUS)

Thanks in advance.

[tresesco]

Assuming that you are mainly stuck at '<EMPNO = {"=(Sum([COMM])/Sum([SAL])) <=10"} >}'. This part of the set analysis returns those EMPNOs for whom, Sum([COMM])/Sum([SAL]) is <=10. For better understanding, learn more about Set Analysis and Advanced Search from help/community.

[Roop · Accepted solution]

I would guess that it means :

For Department (DEPT) number 30; Use the Minimum Sales Amount (MINSAL) multiplied by the bonus (BONUS) amount if the commission (COMM) is less than or equal to 10 times Sales (SAL) - I would guess this should be 10 percent ... and that would be 0.1.

Hope this helps