Find more posts tagged with
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!
@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.
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.
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!

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