Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following statement:
=If(Metric_Charge_Actual_CurrentMonth_EPSI>'0',Metric_MonthEndDate,'')
This statement is in the Settings>Document Properties>Triggers>On Open>Action>Select in Field.
The statement is not appearing in the Current Selection when I close the dashboard and re open it. Should the statement be different?
Hi Quan, you can add the expression to a text box to check the value returned, after setting the expression that retruns the value you wants you can add an action to the same text box, and check if clicking it works as you want. If it works ok, the same action OnOpen should work.
Maybe has something to do with Metric_Charge_Actual_CurrentMonth_EPSI having more than one value, in this case adding a Max() or some other funcion that returns only one value con solve this.