I would like to know how to reset a local variable. I tried with clear all button and it did not work. Thanks for your help.
You can reset using a 'Set Variable' action which can be initiated through a button, text box or trigger for example.
Example on 'Sales Analyis' Tab / What If in this demo app here:
With the help of Macro, you can reset a local variable.
See this thread:
Retrieving data ...