Concat issue

[JR-BejeweledOne]

I am using a concat function to populate a tooltip and it is returning the values but it duplicates each one.  I am not sure how to get rid of the second one on each line.

Concat(
    Filter(Holidays, Country = DropdownCountry.Selected.Result && HolidayDate = DateValue(LabelJanDate.Text)),
    Concatenate(Region, Region & Char(10))
   )

[RandyHayes · Accepted solution]

@JR-BejeweledOne 

You're duplicating the Region in your formula!

Change to:

Concat(
    Filter(Holidays, 
         Country = DropdownCountry.Selected.Result && 
         HolidayDate = DateValue(LabelJanDate.Text)
    ),
    Region & Char(10)
)

I hope this is helpful for you.

[JR-BejeweledOne]

I thought that might be the case but tried something different.   Obviously I tried the wrong thing.

It's a duh sort of moment!  

Thanks a bunch...............

[RandyHayes]

@JR-BejeweledOne 

You were double concatenating - once with the Concatenate and once with the "&" concatenate shorthand.

So either Concatenate(Region, Char(10)) or Region & Char(10)  but not both mixed.  I prefer the & personally just cuz it's much less typing 😉

[JR-BejeweledOne]

That's what you get when you follow someone else's solution and don't recognize that you have to modify something to fit your scenario.  🤣🤣

[RandyHayes]

@JR-BejeweledOne 

Yes...be the leader, not the follower 😂😂😁  You'll always be in the right mind then! 😉

[JR-BejeweledOne]

I'm getting there, not quite there yet, but on the way!

[RandyHayes]

@JR-BejeweledOne 

Keep up the good work!