cancel
Showing results for 
Search instead for 
Did you mean: 

If Logic in where condition

Former Member
0 Kudos

Hi

  I need to filter the data based on user input value.

for example, if user selected period column as 1 then the we need to show measure value that should come across the below filter

Year column -1 & period=12

I tried to do with IDT, there i don't find IF function. Case function is available but not working.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member59613
Contributor
0 Kudos

You can use User Input in formula/variable within a Webi Document using the UserResponse() function.

For example, if I had a Query Filter that prompted me for Quarter, I could use a formula like this:

=If (UserResponse("Enter Quarter:") = "Q1") Then [Sales revenue] -1 Else [Sales revenue] + 1

Not sure if this is what you are trying to do though.  Can you explain more if not?