if condition formula

[ragavalli]

User has two options through radio buttons in the front end:
1. with tax
2. without tax

If the user selects option 1, then I should filter the report based on table.tax>0
If the user selects option 2, then I should filter the report based on table.tax=0

Can anyone tell me how to proceed and write the formula for it

 

[ragavalli]

I have done the following, could anyone let me know if I am right or wrong

I have a taken a parameter field named 'tax' of type string

then I introduced a formula field named 'tax'

if ({?tax} = "Without tax") then
{table.tax}=0
else if({?tax} = "With tax") then
{table.tax}>0



Then in the record selection formula

I just added

@tax


Is this right or any flaws in it?

 

[IanWaterman]

YOu can paste the basic formula into the select statement, just wrap in () and you can use with other clauses.

What you have done looks correct. Is it returning the correct data?

Ian

 

[ragavalli]

Its returning a boolean error

 

[lbass]

Please copy and paste your record selection formula into the thread (report->selection formula->record).

-LB