SUM when column contain a certain word

[#1]

Hi,

I have the following expression:

SUM

(if(DIENSTJAAR <= DIENSTJAAR_TM, if(DIENSTJAAR >= DIENSTJAAR_VANAF, BEDRAG_BEGROOT)))

DIENSTJAAR stands for a year
BEDRAG_BEGROOT stands for a certain amount of money

Now hat i want to do is SUM BEDRAG_BEGROOT, but only where an other  text column (named OMSCHRIJVING) contains the word 'inhuur'.

Does somebody know what to do?

[alexandros17 · Accepted solution]

Hi,

at first pay attention to the ELSE expression that you have not specified in IF;

For The condition you want to add :

1) you can use set analysys

2) you can add the condition if(substringcount ( OMSCHRIJVING, 'inhuur')>0) that returns number of times the word 'inhuur' appear in OMSCHRIJVING

Hope it helps

[#3]

Its working now, thanks!