How to calculate percentage 1

[makk07]

Hi,

I have three columns in my report as follows:
"Actual Amount"
"Budget Amount"
"Variance Amout"(this is Actual Amount - Budget Amount) in dollars

Now I want the fourth column which should show the percentange difference of Actual Amount and Budget Amount.

Please anybody let me know how to do this, I mean how to calculate percentage.

Thank you so much
makk07

 

[AndyMc]

makk07,

One way is to create a formula:

if {table.budgetAmount} <> 0 then
{table.varianceAmount} / {table.budgetAmount} * 100
else
0

Put this on your report and format it with Percent Symbol (Icon on your tool bar).

Andy

 

[AndyMc]

I think I've seen lbass use:

if {table.budgetAmount} <> 0 then
{table.varianceAmount} % {table.budgetAmount}
else
0

to save having to multiply by 100

Andy