How to enable(perform) subtotal and group total?

[mariannextdoor]

Hi,
I have made a report in which I have sorted the list on customer name. 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?

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

 

[IanWaterman]

Sounds like your field Reimbursement.Amount is not a true number but a text number.

If you are sure it will always be entered as a numeber

create a formula
@amount
tonumber(Reimbursement.Amount)

Enter this into details and then you will be able to perform a sum summary on this.

Ian

 

[mariannextdoor]

@IanWaterman

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. heh
Rectified it now.
Thanks a lot.Really greatful of you for the advice and help.
Regards,
Aditya