Hi,
I have a table with some database fields and some calculated values. Sometimes it happens that I divide by 0 or null. As a result I get 'Infinity' in my textbox, is it possible to get rid of this 'message'?
greetz
Im not sure what the return value of that message is .... but if its a string containing the word "Infinity" you could try something like this:
Your field that sometimes returns infinity is: CalculatedField
IIf(CalculatedField = "Infinity", "Write your expression when true", CalculatedField)
That expression is used for a new calculated field and that field you can use in a textbox
|||That could idd be a solution, but isn't there any way to use formatting. I don't like changing the value of my textbox.
greetz
|||I recommend to add a custom code function for the division (in Report -> Report Properties -> Code). Call that custom code function inside of performing the division directly in the expression.
Public Function Divide(ByVal first As Double, ByVal second As Double) As Double
If second = 0 Then
Return 0
Else
Return first / second
End If
End Function
-- Robert
