I want guidance on using the Count and CountDistinct

[TecnologiaMV]

I want guidance on using the Count and CountDistinct functions to filter and count a specific record in a column. For example: {CountDistinct(MV.TP_OCUPACAO, "V")}. I would like to count how many "V" records there are in the "MV.TP_OCUPACAO" column.

[Lech Kulikowski]

Hello,

In this case, you should use the following expression:
{CountDistinctIf(DataBand,DataSource.Column, condition)}

Thank you.