Skip to Content
avatar image
Former Member

If Logic in where condition

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 31, 2014 at 09:06 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded