How to enable(perform) subtotal and group total?

[marian_nextdoor]

Hi,
I have made a report in which I have grouped the list on Employeename. I have another field "Reimbursement.Amount".
I need to summarize this field.
First I need the subtotal and them the grand total.
Problem is that I am not able to use "Insert Summary" option.
When I select the "reimbursement.reimbursementamount" in the "choose the field to summarize", in the "calculate this summary" I am not able to see the "Sum" option. Instead it shows the maximjum options and a few more but I can't see the "Sum" field there.
Can you please tell me how should I do the subtotal and grandtotal for the "ReimbursementAmount" field and enable the Sum field?

I am really stuck with this please help me solve this query.
Also if possible tell me how can add a custom formula for this as an alternative also?

Looking forward to hear from you soon.

Regards,
Aditya

 

[Mile-O]

If you are not getting Sum as an option, then it sounds as if the field you are wanting to Sum isn't a numerical field.

 

[rosito]

U choice "grouping"???

 

[Kempes]

I agree with SJ that the chances are the field is not a value that can be summarised. It may be stored as a string.
In your field explorer, right click and choose show field type. This will confirm it.
You might want to create a formula field and choose...

tonumber(yourfieldnamehere)

or

$yourfieldnamehere if you want it to be currency.

The way you should be able to aggregate your new formula field.

 

[marian_nextdoor]

@rosito

Yes I had chosen grouping earlier but it wasnt working due to the same type mismatch(got to know it now).

@SJ McAbney
@Kempes

Well yes i verifed that reimbursement.amount field it was changed by someone to "text". heh That's why I coudn't think of that being a factor.
But yes shows even minor changes creates a majot impact later
Rectified it now.
Thanks a lot.Really greatful of you for the advice and help.
Regards,
Aditya