In a report I am building I need to add multiple fields together. It looks like in the preview though it is using the values as text and concatenating it end to end. Is there an example of how to do this somewhere?
This is what I have in the expression editor
Any help would be greatly appreciated.
This is what I have in the expression editor
= (Fields.income_monthly10 + Fields.income_monthly9 + Fields.income_monthly8 + Fields.income_monthly7 + Fields.income_monthly6 + Fields.income_monthly5 + Fields.income_monthly4 + Fields.income_monthly3 + (CDbl(Fields.income_annual1) /12) + (CDbl(Fields.income_annual2) /12) ))
Any help would be greatly appreciated.