Alert messages: list values that have met condition

[sibrulotte]

hi,

I've made an alert, and it's awesome:

  = count(if([Indicateur PB sans concordance] = 1,[Poste budgétaire]))>0

I'd like the pop-up to list the fields [poste budgétaire] that have the indicator [indicateur PB sans concordance] set to 1.

I've tried:

= if([Indicateur PB sans concordance]=1,[Poste budgétaire])

But it doesn't work.

What else can I try?

Simon

[maxgro]

perhaps this?

=concat(if([Indicateur]=1,[Poste] & ', '))

change the fields with your

[sibrulotte · Accepted solution]

Yeah, that was part of the answer.

This is what I am looking for:

=CONCAT(DISTINCT if([Indicateur PB sans concordance]=1, [Poste budgétaire]),' - ',if([Indicateur PB sans concordance]=1, [Poste budgétaire]))

Cheers Massimo!