-
Re: Value format in a Table that reports a Custom Calculation
ryoboyle
Jan 30, 2019 9:21 AM
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:
Hopefully this helps.
-
Re: Value format in a Table that reports a Custom Calculation
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.adams
Jan 30, 2019 11:14 AM
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.
-
-
