I have been working with Webi Version: 14.2.4.2410 for a year and a half now and have come across a problem with running input controls of generated values. By generated values I mean something like this "=If(IsNull(Max([Support Periods].[Head of Household] Where ([Support Periods].[Head of Household] = "Yes")));"No";"Yes")"
As you can see I am using a formula that will output either a No or Yes. This works fine for outputting values but falls over when I attempt to filter it with an input control. It works fine to filter with a filter but input controls don't work. First off when I leave it to "values from report" it only shows one values "Yes" even though "No" definitely exists in the result set, secondly if I enter my own values "No" and "Yes" then it appears to work but sometimes doesn't see some of the "No" values.
Any help would be greatly appreciated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.