I need to display Sum of groups and Total in the format of the system locale (e.g. in english- 123,123 in russion- 123 123).
In addition, because the summarised values are integers, I don't want to display the decimal digits.
If I change the Number format property of the field to 0 decimal digits, the format automaticaly is changed to- Custom. In this case the decimal digits are not displayed but the format of the number is not localized.
If I change the Number format back to the System default, the number is displayed according to the system locale but again the decimal digits are displayed.
I tried to solve it by adding a formula instead of using the Group wizard:
CStr(Sum ({sample_header_List_view.total_tests}),0)
But this is o.k. for the Total, and not for the groups sub totals. I didn't find a way to sum by group in a formula.
Helppppppppp
IP Logged
