Due to the specificities of the engine there are some problem with using two aggregate functions by different bands in one expression. Unfortunately, on current moment it is works as is.
Please try to use the following expression instead of the CountIf():
Code: Select all
{Totals.Sum(Datadoor2, door2.kind == "yyyy" && door2.nati == "xxxx" ? 1 : 0)}