Hi,
In my table header i need to show the number of people where there 'rfte' is different from the 'delta van nbfte' (nbfte-rfte). As you can see in my picture the count isn't right. The 'rfte' ain't always 0,00 i just selected this so you could clearly see it ain't the right amount of people.
The formula i'm using is:
'Delta van de NBFTE - Aantal: '&
sum(if(aggr(count(distinct naam_en_voornaam),rfte)<>$(vDelta),1,0) )
vDelta = nbfte - rfte
If somebody knows the right formula, please help 🙂