Error ')' expected - Qlikview

[CamilleA]

Hello,

I've got an issue on a tab, when I active this expression :

=SUM(DISTINCT(IF(REGL_MODE_REG='PRELEVEMENT' and Monthstart(REGL_DATE)=PERIODE_DEBUT, REGL_MONTANT)))

I've got the message "Error in expression : ')' expected".

Can I have some help please ? I don't know what s wrong with this expression.

Thank you 🙂

[Mark_Little]

What are you trying to do?

The brackets seem fine, so to me it points failing to evaluate expression   

[marcus_sommer]

Does this work?

SUM(DISTINCT IF(REGL_MODE_REG='PRELEVEMENT' and Monthstart(REGL_DATE)=PERIODE_DEBUT, REGL_MONTANT))

- Marcus