Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want calculate the number of Action Plan when the risk is relevant and have assigned group, if the group is equal to null exclude it from the account
I have this sentence....
=Count(DISTINCT{<[Nivel de Riesgo]={'Relevante'}>}Action Plan)
and a want Exclude in "Grupo" the null data
select like this
[Nivel de Riesgo] = 'Relevante'
Grupo = ' ' (NULL)
Hi,
Try this,
=Count(DISTINCT{<[Nivel de Riesgo]={'Relevante'}, Grupo -={''}>}Action Plan)
Hope it helps
Hi,
Try this,
=Count(DISTINCT{<[Nivel de Riesgo]={'Relevante'}, Grupo -={''}>}Action Plan)
Hope it helps
Mayil Vahanan Ramasamy escribió:
Hi,
Try this,
=Count(DISTINCT{<[Nivel de Riesgo]={'Relevante'}, Grupo -={''}>}Action Plan)
Hope it helps
HI Mayil
Thanks for the reply,
I have a question about the answer....
why highlighted in red because it appears as if it were a mistake and because the sign of - and + does the same? can you give me a little explanation ..