Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
as part of our board we are displaying what you could call product numbers or identifiers and they can have several different formats. The problem is, that some of them look like this one: 200201E00000309
Because the KPI field we show this is thinks this is purely a number, the E is interpreted incorrectly and the field shows nothing, because the "number" is too large. We have so far not found any way to fix is, except add letters in front using" '...' & " but this is not ideal for us.
If anyone knows how we might change it to not do this, it would be appreciated!
Try to load them as text, like:
...
text([product numbers]) as [product numbers]
...
- Marcus