How to set user defined column to work like component( % inc and compensation amount)

Summary: There is a requirement where I need to create the user defined column where if I enter percentage increase - amount should be calculated and if I give amount - percentage should be calculated. Due to some logic constraints - it needs to be set up like that. Because of evaluation order this is failing. Can this be done?

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):