Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to solve this with a set?
=sum(if(Dos_HoofdId <> Dos_Id,1,0))
tnx
what do you want to reach? if you need to count rows/records where Dos_Hoofdld not equal to Dos_Id, then you can use count function in field, where always will be a value
AT
Timmy, we need more info, you could add your statement in the script and then sum the fields, or possibly use the exists function. With the info provided the If function would do the job you do not always have to use sets.
What is the expression in relation to?
regards,
Neil