Issue with formatting numeric field / DPS 2024.1
Hi, I'm trying to change the formatting of a numeric field but I can't select the OK button. This happens regardless of which format I choose. Any ideas what might be causing this?
Thanks!
-Lasse
Best Answer
-
Thank you for those files. Originally I was able to open the workspace and change any of the formats for that field. As soon as I selected one of the options under "Custom" is when the OK button was disabled. I am not sure if this is a bug or not, but for a workaround, you can use the replace menu to replace your "NULL" values with zero and then the custom format should work for you.
0
Altair EmployeeAnswers
-
I have never seen this before. Does this happen on every numeric field or just this one? Is this a native numeric field (originally numeric or was it converted from text)? Did you try restarting your Monarch session or refreshing your data source?
Are you able to share your workspace/data with Altair? I can provide a secure link so we can take a look at this.
0 -
Thank you @CPorthouse for your reply. The issue only occurs with one field. The field has been converted from text. I tried restarting DPS and refreshing the source.
And yes, I can share the workspace. Thanks for looking this!
0 -
@Lasse you can use this link to upload your workspace and file:
https://ftam1.altair.com/filedrop/cporthouse@altair.com
I will be notified once something has been uploaded.
1 -
Thank you for those files. Originally I was able to open the workspace and change any of the formats for that field. As soon as I selected one of the options under "Custom" is when the OK button was disabled. I am not sure if this is a bug or not, but for a workaround, you can use the replace menu to replace your "NULL" values with zero and then the custom format should work for you.
0 -
It seems that Custom formatting cannot be selected if the first row has a NULL value. It's hard to believe that this is working as planned. But thanks @CPorthouse for the solid workaround!
0
