Skip to main content
Solved

order in a formula ...

  • December 30, 2022
  • 2 replies
  • 39 views

Forum|alt.badge.img+3

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

Best answer by TheTimeSavingCo

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

2 replies

TheTimeSavingCo
Forum|alt.badge.img+31

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


Forum|alt.badge.img+3
  • Author
  • Participating Frequently
  • January 3, 2023

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


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 ... 🙃