Input Control Group Web Intelligence 4.2

[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

[kohesco]

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