Totals

[Guest_imported]

When creating a report I group my query and then when I want to Total I chose count for each group but how do I get it to total a numeric column - there is only minimum, maximum, mode etc

Thanks

 

[Guest_imported]

I am using data from Lotus Notes and crystal is not recognising it as numeric - I need to convert it from a text type to a numeric type. Could anyone help me please.

Thanks

 

[phillyon]

Create a formula field to convert your numeric and use the ToNumber function eg. ToNumber({yourfieldname})

ToNumber("123.45&quot

Returns 123.45.

As for the totals, insert your newly created formula to the report in the details section, right click and choose Insert then SubTotal and select the group that you have created. This will insert a sub total at the group level. Choose Insert / Total if you want an overall calc.