Variable & as a parameter - CRXI 1

[CrystalLion]

I am trying to create a parameter that allows the user to filter items displayed based on a minimum variance percent.

My variance formula is:
if {Inventory_Status.Last_PO_Cost}= 0 then 0 else {Inventory_Status.Last_PO_Cost}/{Inventory_Status.Total_Standard_Cost}-1

So, for example, if the user enters 15 in the report selection prompt, the report would show all items with variances = > 15%. (NOTE-I would like this to include both positive and negative variances.)

My Report Selection line is:
{@Variance %}=> {?Variance % }
where {?Variance % } is a number

Everytime I try to run the report, I get
"A number, currency amount, boolean, date, time, or string is expected here."

What am I doing wrong?

 

[lbass]

This should work. Unless {@Variance %} can be null. Try:

if isnull({Inventory_Status.Last_PO_Cost}) or
{Inventory_Status.Last_PO_Cost}= 0 then
0 else
{Inventory_Status.Last_PO_Cost}/{Inventory_Status.Total_Standard_Cost}-1

-LB

 

[CrystalLion]

Thanks LBASS. I forgot about the isnull.