order in a formula ...

[Gregool]

Hi,

In one column I want to get shown a trend more obvious with colours.

So I want the difference to the week before and in this case a green or a red broken heart.

But somehow I am not allowed to put the heart at the front and the difference at the end ...
(se result: NaN) 🤔

Any idea, what I cannot see right now?

Best regards,
Martin

[TheTimeSavingCo · Accepted solution]

Hm, instead of using `&`, try using `CONCATENATE()`?  That should solve it I think

[Gregool]

Thank you.
But somehow I saw that my old way finally got accepted, too ... 😕🤔
I cannot say, that I changed anything since then, but I tell you:
While a Mercury Retrograde strange things got happen in all stuff of communication ... 🙃