I have a problem on a set of numeric data. On the Field Type (at Data Manager view), it shows the data is "General" format. Unfortunately, it cannot be displayed as numeric figures on chart diagram. Please refer to the following screenshots:
Financial_charge shown on Data Manager:
Financial_charge cannot shown on chart:
I have tried it too. =num(Sum([Financial_charge]),'#,##0.##', '.' , ','), but no luck.