calculating the percentage

[azamatali]

i am working on .net crystal reports.
i have a field tax which gives me the tax %age and
i have amount field.
i want to calculate this tax percentage on sum of amounts say tax% is 5
and amts are 100,800,100
so result shiuld be 5/100*1000
how should i write it.
further i want to add this tax to total amount..

 

[Tolambo]

Hi,
You should insert a formule (@formula) and place it on your crystal report.
The report should read:
{Table.Field}*5/100
This will cause the Formula field to hold the 5% value.
hope that helps:
you may also include "if else statements" if the percentage changes

 

[azamatali]

i am working on .net crystal reports.
i have a field tax which gives me the tax %age and
i have amount field.
i want to calculate this tax percentage on sum of amounts say tax% is 5
and amts are 100,800,100
so result shiuld be 5/100*1000
how should i write it.
further i want to add this tax to total amount..
these 100,800,100 are also database field..
if i apply formula

{Table.Field1}*sum({table.field2})/100
then it is giving error for sum formula
that it should be evaluated later