Percentage Calculations in Reports

[ipr1]

I found a way to show percentage increases/decreases in reports and am passing it along:

Create a text box and insert in it the following (no quotes):

"=(IIf([CurrentAmount]=0,([BaseAmount]*-1),IIf([BaseAmount]=0,([CurrentAmount]*1),([CurrentAmount]-[BaseAmount])/[BaseAmount])))"

I hope this is helpful.