Skip to Content
avatar image
Former Member

Input Control Group Web Intelligence 4.2

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 09, 2017 at 09:16 AM

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

    Add comment
    10|10000 characters needed characters exceeded