Value of Optional Prompt
if you entered anything or not.
-
Create a list report with an Optional Value prompt on City data item.
-
On running the report you will get the output as below with all City prompt values.
-
Now drag the “Layout Calculation” from Toolbox and entered the If-Then-Else and click OK.
-
This way, If you did not select any value by default it will run for all and you will get “2”.
