can we create something like restricted KF or Restrict formula in webi

[Former Member]

Hello all,

we have a report on which the amount column is doubling for certain accounts, Iknow the reason why. basically in the bex query world I would restrict that amount with the date and have a GE variable to get the right amount.

Can we do something similar in webi, where you can just restrict the data in the column based on a variable user inputs?

Thanks

[Former Member · Accepted solution]

I agree with Amit but I have a concern. When the user response is captured in the variable it gets converted to text rather than date format. You might end up converting the date dimention in your formula to char data type.

[Former Member · Accepted solution]

Thank you for replies. This seems like one way of doing it but does seem very difficult and a lot of steps.

[amitrathi239]

Hi,

try like this.

Create one variable in the webi report for user response function which capture the date which user entered in the prompt.

Then add the condition in the webi report column like sum(amount) where (GE="abc" and date=user response variable)

Hope this helps you.

Thanks,

Amit