shackallen
Member
Hello,
I am trying to format amounts in a grid so that if they are negative the are encapsulated in parenthesis and red. I am able to change the font no problem using event rules so making it red is not an issue. I do not want to convert to a string because it is a field users filter using QBE ex. >1000. I have seen some mention of doing a data dictionary override and formatting using a business function. Are there any business functions that would format negative numbers this way?
Thank you!
I am trying to format amounts in a grid so that if they are negative the are encapsulated in parenthesis and red. I am able to change the font no problem using event rules so making it red is not an issue. I do not want to convert to a string because it is a field users filter using QBE ex. >1000. I have seen some mention of doing a data dictionary override and formatting using a business function. Are there any business functions that would format negative numbers this way?
Thank you!