Bit of a newbie to Telerik Reporting. I am working in the standalone Report Designer, and I have been digging around for a way to round values in a calculated field but cannot find anything supported by Telerik. For example:
I'm trying to calculate the total amount owed by creating a calculated field that uses the following logic: Net Weight * Rate = Amount Owed. However, I am trying to establish a way for the rounding to be consistent every time (I have several different reports, and sometimes the differences in rounding will lead to discrepancies between reports).
I have also tried using this formula, but I'm still seeing discrepancies in my reports: = Round( (Fields.UnitPrice * Fields.NetWeight*100) / 100). Additionally, I tried using the VB Script function FormatNumber but I received an error saying this was an undefined function (is it possible to define your own functions?). Simply formatting the field as a number did not help, either.
I need to find a way to tell Telerik to round to two decimal places, but I need it to round either up or down depending on the value so using Floor() and Ceiling() are not going to help.
Thanks in advance!