Hi All,
I am new to this forum and sending my first post where I am facing a small issue in summing two number fields.
Field1 :
Data Type: Number
Format: Single
Decimal :2
Ex: 21.12
Field2 :
Data Type: Number
Format: Single
Decimal :2
Ex:19.23
I placed a text box in the report to sum field 1 and field 2 and put the result in textbox(=[field1]+[field2])
The report is dispalying the total(40.35) when both the fields are having values,but showing blank when one of the field value is blank.
Any ideas how to resolve this issue.
Thanks in Advance.