Percentage sign

Forum|Forum|4 years ago
August 23, 2021
3 replies
389 views

Hi there,

I would appreciate some advice. We have some graphs that contain yearly (stock market) performance data that we update each year. For example in January 2021 we updated the data for 2020. This should not affect previous years. However for some reason we cant figure out InDesign put a % sign infront of some 2018 data which meant one number appeared as a blank so the graph was wrong (unfortunately not spotted manually). Does anyone know why this has happened and how to avoid it happening again. Many thanks

Simon

Bug

This topic has been closed for replies.

Correct answer Luke Jennings3

Your question is a bit unclear, are you asking how to do it, or why it happened? the percent sign indicates an "environment variable" that might have been part of the source data. I don't know how it happened, but this might point you in the right direction:

https://www.lifewire.com/what-are-environment-variables-2625868#:~:text=Environment%20variables%20are%20surrounded%20by,variables%20and%20system%20environment%20variables.

Brad @ Roaring Mouse

Community Expert

How are these graphs created?

Luke Jennings3

Correct answer

Community Expert

Your question is a bit unclear, are you asking how to do it, or why it happened? the percent sign indicates an "environment variable" that might have been part of the source data. I don't know how it happened, but this might point you in the right direction:

https://www.lifewire.com/what-are-environment-variables-2625868#:~:text=Environment%20variables%20are%20surrounded%20by,variables%20and%20system%20environment%20variables.

S

Simon O SAuthor

Participant

Thanks for coming back to me Luke. Apologies for lack of clarity in my question. We are trying to figure out how and why it happened. We didnt touch the previous years data (we had no reason to). I wondered if someone had experienced this before? And importantly how to prevent this ie some way to "lock down" the data so it cant ever change going forwards. We want to give our (unhappy) client reassurance this wont happen in the future.