-
Re: Value format in a Table that reports a Custom Calculation
ryoboyleJan 30, 2019 9:21 AM (in response to camelia)
Hello camelia,
You might have better luck using the FormatNumber function instead of the Round function in your expression. Below I have linked a related post:
How to set decimal positions instead of use ROUND in OL CDS IR
Hopefully this helps.
-
Re: Value format in a Table that reports a Custom Calculation
camelia Jan 30, 2019 9:42 AM (in response to ryoboyle)Hi Ryoboyle, thanks for your reply. I will try it tomorrow and let you know if it works with the data I have.
-
Re: Value format in a Table that reports a Custom Calculation
martin.adamsJan 30, 2019 11:14 AM (in response to camelia)
Hello,
In IR if you have a calculation or custom field that the editor is not recognizing as a numeric value you will only have access to the text formatting. If you place your statement in a Val() function and apply that it will typically trigger the editor to use numeric formatting. You may have to add the Val(your expression) and then apply and say OK to close the dialog and when you open propertied again numeric formatting will be available. This method does not work in all cases but I have used it on several occasions. Also the VB function Format can be useful in creating very specific numeric formatting. Below I used =Format(Peak_Area*1000, "00.00E+00") to format the results from Peak_Area*1000 in a specific scientific notation output that would not be possible in the value format section of the object properties. You can find some information of the format function in the OpenLab CDS help and more online in various VB resource web pages.
-
-