Skip to Content
0
Former Member
May 15, 2010 at 07:39 AM

how to display tax amount fielf

30 Views

hi all,

i have made a WITH HOLDING TAX REPORT in which there is field of TAX RATE , TAX AMOUNT(which is i am displaying twice in report).But the requirement is that if my Report is showing TAX RATE valueis 0 than the field TAX AMOUNT should also display 0.But when i execute my Report it shows me TAX AMOUNT which have some amount after all it has no TAX RATE.

for example:

BASE AMOUNT TAX RATE TAX AMOUNT TAX AMOUNT

100,000 5 5000 5000

110,000 * 0* 3300 3300

you can see that in the second record there is no rate but tax amount is showing.The Tax Amount should be 0.

can anybody do some needful.