Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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!
perhaps this?
=concat(if([Indicateur]=1,[Poste] & ', '))
change the fields with your
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!