If you use a cursor before reportting you can use:

SELECT *, SUM(Amount) AS TotalAm FROM MyTable INTO CURSOR ReportCursor
Then use a ReportCursor as Base for your report, In the field when you want % you can use

ROUND(Amount/TotalAm * 100,2)


>Hi all,
>
>How to create the formula to calculate the percentage out of the total in general format can be used all along ? from mytable.dbf
>
>account amount percentage
>
>11111 100 0.16
>11111 200 0.34
>11111 300 0.50
>---------------
>subtotal 600
>
>22222 200 0.25
>22222 200 0.25
>22222 400 0.50
>--------------
>subtotal 800
>
>
>I got the columns account , amount but need to calculate the percentage but be carefull , each time the account changes the formula of percentage should changed accordingly.
>
>Thanks in advance,