How to get data mesh to work with trailing zeros.
I am working on a project that has 8 different sheets that I am pulling certain information into a report that I am utilizing for a data mesh. On one of my sheets, some of the milestones have a lot of deliverables that are going up to 7.10, 7.11, etc. I am experiencing an issue with "7.10, 8.10, 8.20, 8.30" because the datamesh is identifying them as duplicates with 7.1, 8.1, 8.2, 8.3. When I double click on "7.10" it displays "7.1". Is there a way to force it to be 7.10 when it is double clicked so it doesn't identify as a duplicate?
Best Answer
-
@StaggsJordan I don't know your full setup, but put one of these ' in front of 7.10 like '7.10. That will identify the "number" as a string and keep the trailing 0.
Answers
-
@StaggsJordan I don't know your full setup, but put one of these ' in front of 7.10 like '7.10. That will identify the "number" as a string and keep the trailing 0.
-
Thank you @Samuel Mueller. I will give that a try.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives