Skip to Content
0

Input Control Group Web Intelligence 4.2

Aug 09, 2017 at 01:44 AM

97

avatar image
Former Member

I've created Input Control Group for State and City. If I select State prompt and City prompt value show up in Cell header .I'm writing an incorrect formula :

=If NoFilter(Count([State])) = Count([State]) Then "All State" Else ReportFilter([State]) + " " + If NoFilter(Count([City])) = Count([City]) Then "All City" Else ReportFilter([City])

Please help me !! Thank you !! input-control-2.png

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Koen Hesters Aug 09, 2017 at 09:16 AM
0

=If Count([State)= 1 Then ([State]+" "+ ( If Count([City])= 1 Then [City] Else "All cities")) Else "All state"

Share
10 |10000 characters needed characters left characters exceeded