Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have an expression witch find how many times the string appear in a Field : = count( DISTINCT {Field="DER.5"} Field )
Now i want to improve the expression with a dynamic variable!
Indeed,
I have another field : Month (jan, feb,...)
and I want when I clik on the January The string to find is "DER.1" and February the string become : "DER.2", for March "DER.3" etc...
Do you an idea?
Thanks.
Hi,
Try with something like
Count({< Field = {"DER.$(=MixMatch(Month, 'janv.', 'févr.', 'mars', 'avr.', 'mai', 'juin', 'juil.', 'août', 'sept.', 'oct.', 'nov.', 'déc.'))"} >} Field)
Hope that helps.
Miguel
I have this expression to convert the Field to a number:
mixmatch(Month, 'janv.' , 'févr.' , 'mars' , 'avr.' , 'mai' , 'juin' , 'juil.' ,'août' , 'sept.' ,'oct.' , 'nov.' , 'déc.' )
Hi,
Check with this
= count( DISTINCT {Field="DER.$(mixmatch(Month, 'janv.' , 'févr.' , 'mars' , 'avr.' , 'mai' , 'juin' , 'juil.' ,'août' , 'sept.' ,'oct.' , 'nov.' , 'déc.' ))"} Field )
Or
= count( DISTINCT {Field={'DER.$(mixmatch(Month, 'janv.' , 'févr.' , 'mars' , 'avr.' , 'mai' , 'juin' , 'juil.' ,'août' , 'sept.' ,'oct.' , 'nov.' , 'déc.' ))'}} Field )
Thanks for your answer,
But it seems that it does not work.
Another solution?
Hi,
Try with something like
Count({< Field = {"DER.$(=MixMatch(Month, 'janv.', 'févr.', 'mars', 'avr.', 'mai', 'juin', 'juil.', 'août', 'sept.', 'oct.', 'nov.', 'déc.'))"} >} Field)
Hope that helps.
Miguel
Thank you Miguel,
This is perfect!