Hi All.
I try to generate a report. This report includes two fields with currency format. I need to calculate total of both fields for each person. When I do like =Sum([Field1]) and =Sum([Field2]) I got correct result for each field but when I do like =Sum([Field1] + [Field2]) I have a problem. I'm calculating in footer LastName. How to get a correct result?
Thanks.
I try to generate a report. This report includes two fields with currency format. I need to calculate total of both fields for each person. When I do like =Sum([Field1]) and =Sum([Field2]) I got correct result for each field but when I do like =Sum([Field1] + [Field2]) I have a problem. I'm calculating in footer LastName. How to get a correct result?
Thanks.