Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
Its working now, thanks!