"William" wrote:

> If you want a percentage to be entered as a whole number, change your query
> to:
>
> SELECT avg(budget) as 'CurrBudget' , avg(budget) * (1 + (paramNum/100)) as
> NewBudget
> FROM abc
>
> or easier still is to create a data field which contains the function result
> ie: set dataField1
> = Fields!CurrBudget.Value * Parameters!Report_Parameter_0.Value
>
>
> "mita" wrote:
>
> > Hi guys
> > I need to add a parameter to my query so that when the user enters a number,
> > it gets multiplied by some field in my query.
> >
> > Here is my query:
> > select avg(budget) from abc
> >
> > I want to add a prompt (or parameter) which when entered , "budget" filed
> > will get multiplied by that number.
> >